Why Excel Shared Workbook Does Not Support Access Queries and How to Fix It
Question details
The user is unable to use the legacy Shared Workbook mode in an Excel file connected to an Access database because it contains Excel tables or XML maps.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to enable legacy sharing on an Excel workbook that is actively connected to a Microsoft Access database.
- Observed behavior
- Excel prevents placing the workbook into legacy Shared Workbook mode. Converting the data table to a normal range to bypass this sharing limitation completely disables the data refresh functionality.
Verify whether you are using the older 'Legacy Shared Workbook' feature or modern Co-authoring, and ensure your Access database connection functions properly locally before attempting to share the file.
Transition to Modern Co-authoring or Cloud Sharing
The legacy Shared Workbook feature is outdated and inherently restricts advanced data tools like Excel tables and XML maps. Using modern sharing via OneDrive or SharePoint provides a much better alternative.
Microsoft has largely phased out the legacy Shared Workbook feature because of its strict limitations on data manipulation, including its inability to support Excel tables, XML maps, and Access queries.
Moving your file to a supported cloud environment allows you to use modern Co-authoring, which handles external data connections much more gracefully.
Upload your Excel workbook to a SharePoint library or a OneDrive for Business folder.
Open the workbook in Excel, click the 'Share' button in the top-right corner, and invite your colleagues via their email addresses.
Have your team access the file through the cloud link. While simultaneous editing of the data model might still have restrictions, the file itself can be co-authored without losing the Access query capabilities.
Distribute Individual Workbook Copies
If cloud sharing is not an option for your organization, you can distribute individual copies of the connected workbook to your team members.
Submit Feature Feedback to Microsoft
If your workflow strictly relies on legacy sharing with Access queries, report this limitation to Microsoft to request future accommodations.
Experience Seamless Collaboration with WPS Office
If Excel's legacy sharing limits your team's workflow, consider switching to WPS Office. It provides a robust, free, and lightweight alternative to Microsoft Office, offering excellent compatibility with Excel formats and built-in cloud sharing features designed for modern team collaboration without legacy constraints.
- 1. Download WPS Office: Get the free installer from the official WPS website and complete the quick setup process.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx files with full formatting retained.
- 3. Share via WPS Cloud: Use the integrated sharing features to collaborate with your team efficiently and securely.
Frequently Asked Questions
Why does converting my Excel table to a range stop the data from refreshing?
When an Excel table is linked to an external data source like an Access query, the table's specific structure manages the data binding. Converting it to a normal range severs this structural connection, which permanently disables the ability to refresh the data from the source.
What features are unsupported in Excel's legacy Shared Workbook mode?
Legacy Shared Workbooks are highly restrictive. They do not support Excel tables, XML maps, pivot tables, macros, conditional formatting, data validation, and advanced external data connections like Access queries.
How can multiple people work on an Excel file connected to a database?
The most reliable method is to upload the workbook to SharePoint or OneDrive and use the modern Co-authoring feature. This modern approach supports a much broader range of Excel features and data connections compared to the outdated legacy sharing mode.
