Managing AutoSave when using Modano modular workbooks

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.

Optimizing Excel and OneDrive for Modano Models

Hi Guys,

It's come to our attention that recent changes to OneDrive and Excel's AutoSave functionality negatively impact the performance of Modano, so we wanted to post our recommended workarounds.

The 2 main things which impact performance are:

  1. OneDrive File Collaboration; and
  2. Excel AutoSave.

Both these things are designed to create a Google Sheets-like experience in the desktop version of Microsoft Excel, but for financial models can be extremely annoying.

Using Modano linked workbook projects with OneDrive or SharePoint

Hi Guys,

We've had an increasing number of users experience issues trying to use multi-linked workbook projects from OneDrive or SharePoint, so we wanted to add this post for future reference.

Recommended Approach

Put simply, you need to work locally when building or using Modano multiple workbook projects, even if the files themselves are stored on OneDrive or SharePoint (or any other cloud storage system for that matter). This is to prevent workbook links breaking or becoming corrupted.

Subscribe to RSS - OneDrive