[bitwisebob]

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]

Spreadsheet 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-Spre...

[bjoerns]

We (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

[majkinetor]

Excel 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