A problem with AutoSave

Question

I do many whatif type experiments with creating formulas in Excel. I have turned off all autosave options in the Save page of the Excel options. It is still saving. The behavior is like database behavior wherein if you type or delete one character it saves.

How can i correct this? My worksheets are getting messed up.

Thanks

LH

Answer 1

Turn off the AutoSave switch in Excel’s title bar for the workbook itself; the Save-page setting controls the default for cloud files but may not change a workbook whose AutoSave state was previously remembered.

Stop the current workbook from saving every change

1. Open the workbook.
2. In the upper-left corner of Excel’s title bar, set AutoSave to Off.
3. Close and reopen the workbook, then verify that the switch remains Off. Excel remembers the AutoSave setting separately for each file.
4. Make the temporary formula changes.
5. When finished:
   • Close the workbook and select No when prompted to discard the experiment, or
   • Press Ctrl+S only if you want to retain the changes.

AutoSave saves every few seconds for files stored in OneDrive, OneDrive for Business, or SharePoint Online. This is separate from AutoRecover, which retains recovery information for crashes and can continue working while AutoSave is off.^1^

Because you already disabled the options under File > Options > Save, do not repeat that configuration. Restart Excel once if you have not done so since changing it—the default AutoSave setting takes effect after the application restarts. Then check the workbook-specific title-bar switch again.^1^

Safer method for what-if experiments

For experiments where the original must remain unchanged:

1. Open the original workbook.
2. Immediately select File > Save a Copy.
3. Give the experimental copy a different name.
4. Perform the what-if work only in that copy.

Do this before making any changes. With AutoSave active, using Save As afterward is too late because earlier edits may already have been written to the original.^1^

Recover a workbook that was already overwritten

For a workbook stored in OneDrive or SharePoint:

1. Select File > Save a Copy to preserve its current state.
2. Reopen the original workbook.
3. Select the filename at the top of Excel, then Version History.
4. Find the version from before the unwanted changes and select Open version.
5. Review it and select Restore.

Restoring replaces the current cloud version, so preserve any work you might need with Save a Copy first.^1^

---

References

1. Windows