File Sharing Problems

How to Disable AutoSave for One Shared Excel Workbook

Amos Gikunda Oct 13, 2026 869 views

Question details

The user wants to turn off AutoSave for a specific shared Excel checklist without disabling the feature for other workbooks.

Can You Disable AutoSave for One Shared Excel Workbook?

Product: Microsoft Excel
Device & OS: not provided
Scenario: A team uses a shared Excel checklist where members primarily update their own tasks and view daily changes, but the AutoSave feature causes frequent stalling and file locks.
Observed behavior: When AutoSave is enabled on the shared workbook, simultaneous edits cause performance lags and lockouts, hindering the team's ability to update their tasks.

Before you start

Before modifying your AutoSave or sharing configurations, verify that all team members have manually saved and closed the checklist to prevent accidental data loss or synchronization conflicts.

Solution 1Recommended

Utilize Excel Co-Authoring Instead of Disabling AutoSave

Since Excel does not support permanently disabling AutoSave for a single workbook for all users, optimizing co-authoring practices is the most reliable way to prevent stalling and locking.

Microsoft Excel's AutoSave relies heavily on OneDrive and SharePoint integration. While an individual user can toggle AutoSave off temporarily for their active session, you cannot enforce a 'disabled AutoSave' rule on a specific workbook for the entire team.

Turning off AutoSave completely reduces real-time visibility, forcing manual saves. This significantly increases the risk of merge conflicts, upload failures, and users overwriting each other's data with outdated content.

Store on Microsoft Cloud

Ensure the Excel checklist is uploaded to a centralized OneDrive or SharePoint folder rather than a local network drive to enable proper co-authoring protocols.

Enable Co-Authoring Features

Click the 'Share' button in the upper-right corner of Excel, invite your team members using their Microsoft accounts, and ensure they are granted 'Can Edit' permissions.

Update Office Versions

Instruct all team members to navigate to File > Account > Update Options and click 'Update Now'. Co-authoring functions best when all users are on the latest version of Microsoft 365.

Utilize Excel Co-Authoring Instead of Disabling AutoSave

Local AutoSave Toggle: If an individual user manually toggles AutoSave to 'Off' in the Quick Access Toolbar, they must remember to press Ctrl+S to sync changes, and their edits may lock specific cells for other users until saved.

Free Microsoft Office alternative

Experience Seamless Collaboration with WPS Office

If Microsoft Excel's AutoSave dependencies and file locking issues continue to disrupt your team's checklist updates, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with robust cloud collaboration features tailored for smooth team productivity.

1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx shared checklist directly without worrying about formatting loss.
3. Share via WPS Cloud: Use the built-in WPS Cloud sharing feature to generate an edit link for your team, allowing smooth co-authoring without aggressive file locks.

Highly compatible with Microsoft Excel (.xlsx) formatsLightweight application that prevents stalling on complex shared filesFree to use with intuitive real-time cloud collaboration tools

microsoft office alternative - wps office

Frequently Asked Questions

Can I turn off AutoSave for a specific document only?

You can temporarily toggle AutoSave off using the switch in the top-left corner of the Excel window for your current session on a specific file. However, this setting is not permanent and cannot be enforced for all other users accessing that shared workbook.

Why does my shared Excel file keep locking for editing?

File locking typically occurs when a user opens the file in a non-cloud environment (like an older network drive), uses an outdated version of Excel that doesn't support co-authoring, or if someone has left the file open with unsaved changes while AutoSave is turned off.

What happens when AutoSave is turned off in a shared workbook?

When AutoSave is disabled, you lose real-time visibility of other users' edits. You must save manually to push your updates and pull theirs, which dramatically increases the risk of merge conflicts and file synchronization failures.

How can we reduce lag in a shared Excel checklist?

To minimize stalling, clear unnecessary formatting, remove excessive conditional formatting rules, avoid volatile array formulas, and ensure all team members have a stable internet connection for continuous syncing to OneDrive or SharePoint.

Document & File Issues