Co-Authoring

AutoSave is one of the most confusing and frustrating features of Microsoft Excel, primarily because most people don't understand it properly. So I'm writing this post to clarify how it works for future reference.

What is AutoSave?

AutoSave is Microsoft's attempt to replicate the way Google Sheets automatically saves changes in real time, thereby preventing the need to ever Save or Save As.

This is great in theory but not so great when building complex financial models.

How do you deal with collaboration and sharing? For enterprise clients that need multiple people changing assumptions for different business units or even the same business units but different assumptions, how do you create an environment where multiple people can edit assumptions simultaneously and have only one version of the truth?