3 ms·
While we're talking about Excel: Are there any good tools available for version control and/or diffing of spreadsheets? If my coworker updates a formula in ce
by bitwisebob 9y ago
While we're talking about Excel:
Are there any good tools available for version control and/or diffing of spreadsheets?
If my coworker updates a formula in cell E3 and emails it to be, is there any way for me to know what changed?
- will_pseudonym 9y agoSpreadsheet Compare is built into Excel/Office. It's a relatively unknown tool since it came out in 2013. See: https://support.office.com/en-us/article/Basic-tasks-in-Spreadsheet-Compare-f2b20af8-a6d3-4780-8011-f15b3229f5d8 https://support.office.com/en-us/article/Basic-tasks-in-Spre...
- bjoerns 9y agoWe (disclaimer: I'm the co-founder) have developed a Git-based add-on for Excel workbooks. Basically, it starts where Git left off in the Excel world. Here's a short blog post how it works out for one of our open source projects: https://www.xltrail.com/blog/xlwings-is-now-on-xltrail https://www.xltrail.com/blog/xlwings-is-now-on-xltrail
- majkinetor 9y agoExcel shared workbook is versioned and comes OTB. You can see user edits, old cell value and new one. It gets latest data on save and even does merge