How to Edit Excel Workbooks with Web Queries When Sharing Online
Question details
Users need to collaboratively edit Excel workbooks online but face restrictions due to unsupported web queries.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to share and edit an Excel workbook containing web queries using Excel for the web.
- Observed behavior
- Excel for the web displays a Compatibility Report and prevents collaborative editing because the workbook contains unsupported web queries.
Determine whether preserving the live web queries is strictly necessary for your team's workflow, as making the file compatible for browser-based collaboration will require removing these queries.
Create a Copy to Remove Unsupported Web Queries
Use this method to automatically strip out unsupported features so the workbook can be collaboratively edited in the browser.
Excel for the web does not support editing files with active web queries. By creating a copy, Excel safely removes these advanced features while retaining your core data.
Navigate to the shared file online and attempt to open it in your web browser.
When the Compatibility Report appears, click on the 'Open' menu, select 'Open in browser', and then click 'Edit a Copy'.
Enter a new file name for the copied workbook and save it. The copied version will remove the web queries and enable collaborative web editing.

Use the Desktop Excel Application
Use this solution if you must preserve the web queries and advanced data connections within your workbook.
Manage Complex Spreadsheets Seamlessly with WPS Office
If you frequently encounter limitations with browser-based spreadsheet editors, consider switching to WPS Office. As a free, lightweight, and powerful alternative, WPS Spreadsheet offers robust local editing capabilities without compromising on format compatibility.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Install the software: Run the installer and follow the simple on-screen instructions to set up the software.
- 3. Open your workbook: Launch WPS Spreadsheet and open your Excel file to edit your data and queries locally.

Frequently Asked Questions
Why does Excel for the web display a Compatibility Report?
Excel for the web does not support certain advanced desktop features, such as VBA macros or web queries. When it detects these elements in a file, it shows a Compatibility Report and restricts collaborative editing to prevent data corruption.
Will I lose my data if I edit a copy in the browser?
No, creating a copy retains all your standard cell data, values, and text. However, the specific unsupported features (like the live web queries) will be removed or converted to static text in the copied version.
Can I edit shared files with web queries without making a copy?
To edit the file without making a copy and losing the web queries, you must open the original file using the desktop version of Excel rather than the browser-based editor.




