4 ms·

Which feature have I mischaracterized?

by tschwimmer 6y ago

carlmr 6y ago
If there's a good way to version control Excel I'm intrigued.
- LeonB 6y ago
  With sharepoint you can check the file in/out and see version history, possibly with a comment on each versio. But it’s not very similar to version control system. Particularly since formulas and data live together. Better than nothing. (As soon as it gets harder to use, people revert to saving files locally and emailing them to each other... so it’s about as good as it can be really)
- IggleSniggle 6y ago
  “Revision Tracking” is the built-in tool for this, which is about as good as most no-code solutions I’ve seen. There’s a git extension, git-xltrail, if you want to use Excel with git.
- zubairq 6y ago
  I actually built an external version control system for Excel a few years ago. It is actually a hard problem to solve, as you have to figure out when a user cuts and pastes between worksheets to be useful.
anang 6y ago
I can’t speak for OP but doesn’t office365 have some sort of versioning mechanism for documents? Through share point or teams or something?
- Rastonbury 6y ago
  No where near as useful or powerful as Git
  - bryanrasmussen 6y ago
    not having something as powerful as what is generally considered the best is not the same as not having something.
  - 737maxtw 6y ago
    Most low code tools I've seen companies drop 6-7 figures on would be worlds better if they had Excel's level of version control. I've seen low code vendors claim you can do reviews in git... but its an experience not unlike reviewing changes to a generated hibernate or entity framework xml. Its not really reviewable
StillBored 6y ago
There is a "user facing front-end" as well. UserForms give you customizable dialogs for displaying/prompting the user. I frankly haven't used vba for a couple decades at this point, but if you dig deep enough its pretty much all there. Combined with sharepoint/etc you can probably get a lot of the UI to be web facing as well.

Which feature have I mischaracterized?

carlmr 6y ago

If there's a good way to version control Excel I'm intrigued.

LeonB 6y ago
With sharepoint you can check the file in/out and see version history, possibly with a comment on each versio. But it’s not very similar to version control system. Particularly since formulas and data live together. Better than nothing. (As soon as it gets harder to use, people revert to saving files locally and emailing them to each other... so it’s about as good as it can be really)
IggleSniggle 6y ago
“Revision Tracking” is the built-in tool for this, which is about as good as most no-code solutions I’ve seen. There’s a git extension, git-xltrail, if you want to use Excel with git.
zubairq 6y ago
I actually built an external version control system for Excel a few years ago. It is actually a hard problem to solve, as you have to figure out when a user cuts and pastes between worksheets to be useful.

anang 6y ago

I can’t speak for OP but doesn’t office365 have some sort of versioning mechanism for documents? Through share point or teams or something?

Rastonbury 6y ago
No where near as useful or powerful as Git
- bryanrasmussen 6y ago
  not having something as powerful as what is generally considered the best is not the same as not having something.
- 737maxtw 6y ago
  Most low code tools I've seen companies drop 6-7 figures on would be worlds better if they had Excel's level of version control. I've seen low code vendors claim you can do reviews in git... but its an experience not unlike reviewing changes to a generated hibernate or entity framework xml. Its not really reviewable

StillBored 6y ago

There is a "user facing front-end" as well. UserForms give you customizable dialogs for displaying/prompting the user. I frankly haven't used vba for a couple decades at this point, but if you dig deep enough its pretty much all there. Combined with sharepoint/etc you can probably get a lot of the UI to be web facing as well.