Excel Guides

How to change an invalid autosave folder in Excel

If you're getting an error message that your autosave folder is invalid, there are a few things you can do to fix the problem.

First, try restarting Excel. This will sometimes clear up the problem on its own.

If that doesn't work, you can try changing the location of your autosave folder. To do this, go to File > Options > Save. Under "Save workbooks", look for the "Default file location" field. Here, you can enter a new path for your autosave folder.

If you're still having trouble, it's possible that your registry settings are incorrect. To fix this, you'll need to edit the registry. Warning: Editing the registry is risky and can potentially damage your computer. If you're not comfortable doing this, we recommend seeking help from a qualified IT professional.

To edit the registry:

  1. Close Excel.
  2. Open the Registry Editor. You can do this by opening the Start menu and typing "regedit" into the search bar. Press Enter to open Registry Editor.
  3. Navigate to the following key:
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options]
  1. In the right pane of Registry Editor, double-click on "OPEN".
  2. "OPEN" should now be highlighted in the right pane. In the "Value data" field, enter a new path for your autosave folder.
    • (Note: The path must be enclosed in quotation marks.)
  1. "OPEN" should now be highlighted in the right pane. In the "Value data" field, enter a new path for your autosave folder.
  • (Note: The path must be enclosed in quotation marks.)
  1. "OK" to save your changes and close Registry Editor.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.