Fix WEBSERVICE #VALUE! Errors in Excel for the Web
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.

- 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.
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.
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.
In Excel for the web, choose Open in Desktop App from the workbook toolbar or editing menu.
Select the cell containing =WEBSERVICE(...) and verify that the URL points to the intended endpoint.
In desktop Excel, use Formulas > Calculate Now, check the result, and select Save. Do not rely on the browser to refresh the WEBSERVICE formula.

Populate the workbook through a separate integration
Use an external workflow when browser users need updated data without running WEBSERVICE in the workbook.
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.

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.




