How to Fix Excel AutoSave Errors for Macro Workbooks in OneDrive
Question details
Users experience intermittent AutoSave failures when working with macro-enabled Excel workbooks stored in OneDrive.

- Product
- Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- Saving and collaborating on macro-enabled (.xlsm) workbooks stored in OneDrive.
- Observed behavior
- The AutoSave feature is intermittently disabled for the workbook, although manual saving using Ctrl+S continues to work successfully.
Ensure that your workbook is properly saved in the Macro-Enabled Workbook format (.xlsm) and that both your Microsoft Office application and OneDrive sync client are updated to their latest versions.
Isolate and Identify Problematic Macros
Determine if a specific macro is blocking the AutoSave function by testing the workbook incrementally.
Often, a specific VBA procedure or unsupported macro action conflicts with OneDrive's real-time AutoSave capabilities. By stripping the macros and adding them back one by one, you can isolate the exact code causing the interruption.
Open the VBA editor by pressing Alt+F11. Right-click your modules in the Project Explorer, select 'Export File', and save them to a local folder.
Save a copy of your workbook as a standard Excel Workbook (.xlsx). Open this new file in OneDrive and check if the AutoSave toggle remains turned on without issue.
Save the working file as a Macro-Enabled Workbook (.xlsm). Add a very simple test macro, save, and verify AutoSave works. Then, import your original modules one at a time, testing AutoSave after each addition until the error reappears.

Verify File Format and Software Versions
Basic configuration issues with file extensions or outdated software can often interrupt OneDrive AutoSave functions.
Edit Macro-Enabled Workbooks Seamlessly with WPS Office
If Excel's AutoSave continues to fail with your OneDrive macros, consider switching to WPS Office. It is a free, lightweight, and easy-to-use alternative that offers seamless migration, high compatibility with Microsoft Office formats, and its own reliable cloud sync for macro workbooks.
- 1. Download and Install: Get WPS Office from the official website and install it on your device in minutes.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsm file directly without needing any format conversion.
- 3. Enable WPS Cloud Sync: Sign in to your WPS account and enable WPS Cloud to automatically back up and sync your macro-enabled workbooks reliably.

Frequently Asked Questions
Why does AutoSave turn off when I add a macro in Excel?
AutoSave may disable itself if the macro contains unsupported features, modifies the workbook structure in a way incompatible with co-authoring, or if the file isn't properly saved in the .xlsm or .xlsb format required for macros.
Can I use OneDrive AutoSave with .xlsb or .xlsm files?
Yes, OneDrive AutoSave supports both Excel Macro-Enabled Workbooks (.xlsm) and Excel Binary Workbooks (.xlsb), provided the embedded macros do not conflict with Office's real-time co-authoring synchronization.
How do I find out which macro is causing the AutoSave error?
Export your macro modules from the VBA editor and save the file as a macro-free .xlsx. Then, convert it back to .xlsm and re-import your macros one by one, checking the AutoSave toggle after each addition until the error occurs.




