File Sharing Problems

Should You Enable AutoSave for Shared Excel XLSM Files?

Kushani NimanthikaKushani Nimanthika Nov 4, 2026 872 views

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.

Should You Enable AutoSave for Shared Excel XLSM Files?
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.
Before you start

Ensure you have a stable internet connection and that all collaborators are using a Microsoft 365 subscription that supports real-time co-authoring.

Solution 1Recommended

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.

1
Upload to SharePoint or OneDrive

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.

2
Turn on AutoSave

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'.

3
Review Macro and Power Query Compatibility

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.

4
Create a Manual Backup

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.

Enable AutoSave and Verify Workbook Compatibility
Macro Limitations: If a macro applies complex formatting, filters, or restructures the workbook while others are typing, it may interrupt the co-authoring session for all users.
Seamless Collaboration Tool

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. 1. Open the XLSM File: Launch WPS Spreadsheets and open your macro-enabled workbook.
  2. 2. Upload to WPS Cloud: Go to 'Menu' > 'Save As' and select 'WPS Cloud' to upload your document for auto-saving.
  3. 3. Share with Collaborators: Click the 'Share' button in the top right corner to generate an edit link for your team members.
  4. 4. Edit in Real-Time: Collaborate smoothly with your team while WPS Office automatically syncs your changes to the cloud.
Highly compatible with Microsoft Excel .xlsm, .xlsx, and .xls formatsFree built-in cloud storage for real-time document syncing and sharingLightweight application with a familiar, easy-to-use interface
microsoft office alternative - wps office

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.