When you open a finance workbook in Word for the web or desktop, AutoSave may show the file as read-only even though no one else has it locked. This typically happens because the workbook contains Office Add-ins, macros, or external data connections that trigger OneDrive for Business file validation rules. The file is not actually locked by another user, but the combination of Active Content and SharePoint library settings forces the document to open in read-only mode.
This guide explains why finance workbooks with macros or add-ins open read-only, how to adjust your OneDrive and Word settings to restore full editing with AutoSave, and what to do if the problem persists. You will learn the exact settings to change, how to test the fix, and how to prevent the issue from recurring on other workbooks.
Key Takeaways: Fixing Read-Only AutoSave for Finance Workbooks
- OneDrive settings > Sync and backup > Advanced settings > Files On-Demand: Enables local sync and prevents cloud-only files from opening read-only due to network latency.
- Word Options > Trust Center > Trust Center Settings > Active Content Settings: Disabling “Enable all macros” and “Trust access to the VBA project object model” reduces validation triggers.
- SharePoint library settings > Library Settings > Versioning Settings > Require Check Out: Setting to “No” prevents read-only lock when a file has active content.
Why Finance Workbooks Open Read-Only with AutoSave
Word for the web and the Word desktop app use AutoSave to continuously save changes to OneDrive and SharePoint. When a workbook contains Active Content such as macros, ActiveX controls, or external data connections, SharePoint applies a read-only flag to the file until the user explicitly enables editing. This behavior is part of the SharePoint File Validation feature, which treats any file with executable content as potentially unsafe.
The Role of SharePoint File Validation
SharePoint Online scans files for active content when they are opened through the browser or the sync client. If the scan detects macros or add-ins, SharePoint sets the file to read-only and displays a yellow bar in Word with the message “We found active content in this file. Click Enable Editing to work with AutoSave.” This is not a sync conflict. It is a security measure that forces the user to confirm the file is safe before AutoSave becomes active.
Why Finance Workbooks Are Affected
Finance workbooks commonly include macros for data import, external connections to SQL databases or Excel spreadsheets, and custom add-ins for financial modeling. The presence of any of these elements triggers the validation check. Even if the macros are signed by a trusted publisher, the file still opens read-only until the user clicks “Enable Editing.”
Steps to Restore AutoSave Editing for Finance Workbooks
Follow these steps in order. Test after each step to see if the workbook opens with AutoSave active.
- Enable Files On-Demand in OneDrive
Open OneDrive settings by right-clicking the cloud icon in the system tray and selecting Settings. Go to the Sync and backup tab and click Advanced settings. Under Files On-Demand, make sure the toggle is set to On. This ensures the file is fully synced to your local device before Word opens it, reducing network-related read-only triggers. - Disable Macro Validation in Word Trust Center
Open Word and go to File > Options > Trust Center > Trust Center Settings > Active Content Settings. Under Macro Settings, select “Disable all macros with notification.” Under Developer Macro Settings, uncheck “Trust access to the VBA project object model.” Click OK. This tells Word not to treat macros as active content until you explicitly enable them, which bypasses the SharePoint validation flag. - Turn Off Require Check Out on the SharePoint Library
Go to the SharePoint document library that contains the finance workbook. Click the gear icon and select Library Settings. Under General Settings, click Versioning settings. Set “Require Check Out” to No. Click OK. Files with check-out enabled are locked to one user until checked in, and SharePoint treats active content files as checked out to the system, causing read-only mode. - Clear the Office Cache
Close all Office apps. Open the Run dialog with Windows key + R and type%localappdata%\Microsoft\Office\16.0\OfficeFileCache. Press Enter. Delete all files in this folder. Restart Word and open the workbook. This removes stale cached file versions that may retain the read-only flag. - Test with a New Blank Workbook
Create a new blank document in Word and save it to the same SharePoint library. Add a simple macro using the Developer tab. Save and reopen the file. If AutoSave works, the issue is specific to the original workbook. If not, the problem is at the library or tenant level.
If the Workbook Still Opens Read-Only After the Fix
If none of the above steps resolve the issue, the problem may be caused by an Office Add-in or a tenant-wide policy. Check the following three areas.
Office Add-ins Interfering with AutoSave
Some third-party add-ins, especially those that connect to financial data sources, can force Word to open files in compatibility mode or read-only mode. Go to Word > File > Options > Add-ins. At the bottom, next to Manage, select COM Add-ins and click Go. Uncheck all add-ins except the Microsoft ones. Restart Word. If the workbook opens correctly, re-enable add-ins one by one to find the culprit.
Tenant Policy Blocking AutoSave for Files with Macros
Your Microsoft 365 admin may have set a SharePoint Online policy that blocks AutoSave for files containing active content. As a user, you cannot change this. Contact your admin and ask them to review the policy at Microsoft 365 admin center > SharePoint > Policies > Sharing. They can search for “Restrict file types” or “Block file types” and remove the macro-enabled file type restriction.
File Corruption or Incomplete Migration
If the workbook was migrated from an on-premises server or a different cloud platform, its internal metadata may be corrupted. Open the file in Word desktop, go to File > Info, and click Check for Issues > Inspect Document. Remove any personal information or hidden metadata. Save a copy with a new name and test AutoSave.
AutoSave Behavior: Desktop vs Web vs Mobile
| Item | Word Desktop | Word for the Web |
|---|---|---|
| AutoSave trigger | Continuous save every few seconds | Manual save or idle timer |
| Read-only on active content | Shows yellow bar, user must click Enable Editing | Shows yellow bar, user must click Enable Editing |
| Requires Files On-Demand | Yes, for local sync | Not applicable, browser-based |
| Macro execution | Allowed after enabling | Not supported in the browser |
Word for the web does not run macros at all, so finance workbooks with macros will always open read-only in the browser. Use the desktop app if the workbook requires macro execution. On mobile devices, AutoSave is not available in the Word mobile app for files stored on OneDrive for Business; you must use the desktop or web version.
You now know the exact combination of settings that cause finance workbooks to open read-only with AutoSave and how to fix each one. Start by enabling Files On-Demand and adjusting the Word Trust Center macro settings. If the issue persists, ask your SharePoint admin to check tenant policies. For workbooks that must run macros, always use the Word desktop app and keep the Trust Center setting at “Disable all macros with notification” to avoid the read-only flag.