File Format & Compatibility

How to Edit Excel Workbooks with Web Queries When Sharing Online

Bushra ParveenBushra Parveen Nov 3, 2026 870 views

Question details

Users need to collaboratively edit Excel workbooks online but face restrictions due to unsupported web queries.

How to Edit Excel Workbooks with Web Queries When Sharing Online
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook in Excel for the web

Navigate to the shared file online and attempt to open it in your web browser.

2
Select Edit a Copy

When the Compatibility Report appears, click on the 'Open' menu, select 'Open in browser', and then click 'Edit a Copy'.

3
Save the new file

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.

Create a Copy to Remove Unsupported Web Queries
Ready for Collaboration: The newly saved file can now be shared and edited by multiple users simultaneously in Excel for the web.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
  2. 2. Install the software: Run the installer and follow the simple on-screen instructions to set up the software.
  3. 3. Open your workbook: Launch WPS Spreadsheet and open your Excel file to edit your data and queries locally.
Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Handle advanced data features effortlessly without web browser restrictions.Lightweight application that runs smoothly on Windows, Mac, and Linux systems.Familiar and intuitive user interface ensures a seamless migration.
microsoft office alternative - wps office

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.