Function Problems

Fix WEBSERVICE #VALUE! Errors in Excel for the Web

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

The user wants to understand why a WEBSERVICE formula works in desktop Excel but returns #VALUE! in Excel for the web or a SharePoint web part.

Fix WEBSERVICE #VALUE! Errors in Excel for the Web
Product
Excel for the web and SharePoint
Device & OS
not provided
Scenario
A workbook uses WEBSERVICE to retrieve XML or other data from a web endpoint and is opened in a browser.
Observed behavior
The formula returns #VALUE! in Excel for the web or a SharePoint web part, although it works in desktop Excel.
Before you start

Identify the cell containing the WEBSERVICE formula and confirm that its URL and expected result work in a supported desktop version of Excel. Check whether the workbook needs live data in the browser or whether periodically updated values are sufficient.

Solution 1Recommended

Open the workbook in desktop Excel to use WEBSERVICE

Use desktop Excel when you need the existing WEBSERVICE formula to retrieve its result.

WEBSERVICE is not supported in Excel for the web. A SharePoint web part that displays the workbook does not add support for the function.

1
Open the workbook in Excel

In Excel for the web, choose Open in Desktop App from the workbook toolbar or editing menu.

2
Check the formula

Select the cell containing =WEBSERVICE(...) and verify that the URL points to the intended endpoint.

3
Recalculate and save

In desktop Excel, use Formulas > Calculate Now, check the result, and select Save. Do not rely on the browser to refresh the WEBSERVICE formula.

Open the workbook in desktop Excel to use WEBSERVICE
Browser limitation: Saving a calculated result does not make WEBSERVICE supported in Excel for the web. Browser recalculation and display may differ from desktop Excel.
Free Microsoft Office alternative

Work with Excel files in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Excel file compatibility, making it easy to move everyday spreadsheet work. It does not fix the WEBSERVICE limitation in Excel for the web; check formula compatibility before migrating a workbook.

Open and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for everyday workbook tasksWork with spreadsheet data in a free, lightweight office suiteMove existing files without rebuilding every workbook from scratch
microsoft office alternative - wps office

Frequently Asked Questions

Why does WEBSERVICE work on desktop but return #VALUE! in the browser?

WEBSERVICE is not supported in Excel for the web. Open the workbook in a supported desktop version of Excel to run the formula.

Can a SharePoint web part run my WEBSERVICE formula?

A SharePoint web part displaying an Excel workbook does not add WEBSERVICE support. Use desktop Excel or populate the workbook through a separate integration.

Can Power Automate replace WEBSERVICE for browser users?

A Power Automate flow can retrieve data through an appropriate connector and write it to an Excel table stored in OneDrive or SharePoint. Connector availability, authentication, and licensing depend on your environment.

Will saving the workbook in desktop Excel enable browser refresh?

No. Saving a calculated result does not enable WEBSERVICE in Excel for the web. Use desktop Excel or an external workflow when the data needs updating.

How can I request WEBSERVICE support in Excel for the web?

Use Help > Feedback in Excel for the web, if available, to describe your workflow and request support for the function.