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?
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?
See: https://support.office.com/en-us/article/Basic-tasks-in-Spre...
You can see user edits, old cell value and new one.
It gets latest data on save and even does merge