Should You Enable AutoSave for Shared Excel XLSM Files?
Question details
The user wants to know if the AutoSave feature should remain enabled when multiple users are collaborating on a macro-enabled Excel workbook (.xlsm) stored on SharePoint.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Co-authoring a shared macro-enabled (.xlsm) workbook in Microsoft 365.
- Observed behavior
- Evaluating feature limitations, macro compatibility, and the safety of simultaneous editing before turning on AutoSave.
Ensure you have a stable internet connection and that all collaborators are using a Microsoft 365 subscription that supports real-time co-authoring.
Enable AutoSave and Verify Workbook Compatibility
Keep AutoSave enabled for supported SharePoint-stored workbooks so changes are saved automatically during co-authoring, provided your macros are compatible.
AutoSave supports real-time co-authoring in Microsoft 365 when multiple users edit a file stored on SharePoint or OneDrive. However, because macro-enabled workbooks (.xlsm) can execute background code, you must ensure that your specific VBA scripts do not conflict with simultaneous editing.
Ensure your XLSM file is saved to Microsoft SharePoint or OneDrive, as cloud storage is required for the AutoSave and real-time co-authoring features to function.
Open the workbook in Microsoft Excel and click the 'AutoSave' toggle switch located in the top-left corner of the Quick Access Toolbar to turn it 'On'.
Check the workbook's VBA macros and Power Query data connections. Navigate to the 'Developer' tab and click 'Visual Basic' to review your code. Ensure there are no macros that lock the workbook or trigger massive sheet-wide changes during co-authoring.
Before initiating major changes with multiple users, go to 'File' > 'Save a Copy' to maintain a secure local backup of the XLSM file in case of macro conflicts.

Share and Edit Macro-Enabled Workbooks with WPS Office
WPS Office provides a highly compatible and lightweight platform for handling complex Excel files. You can securely store, share, and collaborate on your XLSM files using WPS Cloud without worrying about compatibility issues.
- 1. Open the XLSM File: Launch WPS Spreadsheets and open your macro-enabled workbook.
- 2. Upload to WPS Cloud: Go to 'Menu' > 'Save As' and select 'WPS Cloud' to upload your document for auto-saving.
- 3. Share with Collaborators: Click the 'Share' button in the top right corner to generate an edit link for your team members.
- 4. Edit in Real-Time: Collaborate smoothly with your team while WPS Office automatically syncs your changes to the cloud.

Frequently Asked Questions
Why does AutoSave turn off automatically when I open an XLSM file?
AutoSave might turn off automatically if the file contains features unsupported by Excel's co-authoring engine, such as legacy shared workbook features, strict passwords, or unsupported Power Query setups.
Is it safe to run VBA macros while others are co-authoring the file?
Running macros during a live co-authoring session can be risky. If a macro performs heavy background calculations or modifies cells that other users are actively editing, it might interrupt the session or cause syncing conflicts.
How do I recover a previous version of a shared XLSM file?
In Excel, click the file name at the very top of the application window and select 'Version History' from the drop-down menu. You can then view and restore previous versions of your cloud-stored file.




