Excel Error Codes

Fix Excel WEBSERVICE #VALUE! After a Python in Excel Update

Olivia MillerOlivia Miller Nov 13, 2026 869 views

Question details

The user needs to resolve the Excel WEBSERVICE #VALUE! error that appears after a Python in Excel update and restore web data lookup functionality.

Fix Excel WEBSERVICE #VALUE! After a Python in Excel Update
Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook uses the WEBSERVICE function to fetch web data, but it starts returning #VALUE! after a Microsoft 365 update, especially when Python in Excel is enabled.
Observed behavior
The WEBSERVICE formula returns #VALUE! instead of the expected web response.
Before you start

Confirm your current Excel version and whether the workbook blocks external data connections. If you plan to use the VBA workaround, check that macros are allowed by your Trust Center security settings.

Solution 1Recommended

Update Excel to Version 2311 Build 17005.20000 and Enable External Data Connections

Use this recommended fix first because the WEBSERVICE #VALUE! issue was addressed in Microsoft 365 Version 2311, Build 17005.20000.

The WEBSERVICE #VALUE! error was fixed in Microsoft 365 Version 2311, Build 17005.20000. After updating, Excel may require external data connections to be enabled for the workbook before WEBSERVICE can fetch web data.

1
Check the installed Excel version

Open Excel and click File > Account > About Excel to verify that you are on Version 2311, Build 17005.20000 or later.

2
Update Microsoft 365

Click File > Account > Update Options > Update Now, then restart Excel after the update completes.

3
Enable external data connections

Open the affected workbook, click File > Options > Trust Center > Trust Center Settings > External Content, and choose to enable data connections for this workbook.

4
Refresh the WEBSERVICE formula

Select the formula cell and click Formulas > Calculate Now to confirm the #VALUE! error is replaced by the expected web response.

Update Excel to Version 2311 Build 17005.20000 and Enable External Data Connections
Update resolved: After installing the fix and allowing external data connections, the WEBSERVICE function should return data normally.
Free Microsoft Office alternative

Switch to WPS Spreadsheets as a Free Alternative When Excel WEBSERVICE Keeps Failing

If Microsoft Excel continues to show #VALUE! for WEBSERVICE after updates, WPS Office offers a free, lightweight Office alternative. WPS Spreadsheets supports familiar .xlsx workbooks and ribbon tools, so you can continue daily spreadsheet tasks without the same update-related external connection friction.

  1. 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free to get the latest version.
  2. 2. Install and open WPS Spreadsheets: Run the installer, open WPS Spreadsheets from the WPS Office home screen, and sign in if needed.
  3. 3. Open your Excel workbook: Click Menu > Open in WPS Spreadsheets, select your .xlsx file, and review formulas or continue editing with familiar ribbon tools.
Avoid Excel build-specific WEBSERVICE update errorsOpens, edits, and saves .xlsx and .xls files with strong compatibilityFree, lightweight Office suite with a familiar ribbon interfaceEasy migration for existing Excel workbooks and data
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel WEBSERVICE return #VALUE! after a Python in Excel update?

A Microsoft 365 update changed how external data connections are handled for WEBSERVICE when Python in Excel is enabled. The issue was fixed in Version 2311, Build 17005.20000, and affected workbooks must allow external content.

How do I enable external data connections for a workbook that uses WEBSERVICE?

Open the workbook, go to File > Options > Trust Center > Trust Center Settings > External Content, and enable data connections for that workbook. Then recalculate the formula.

Can I avoid the error without updating Excel?

If your security policies allow macros, you can use a VBA function based on MSXML2.ServerXMLHTTP.6.0 and replace WEBSERVICE calls with that function as a temporary workaround.

Does the VBA MSXML2 workaround work in 64-bit Excel?

Yes, users have reported that the MSXML2.ServerXMLHTTP.6.0 VBA function works in 64-bit Excel, but it depends on your organization's macro security settings.

Can WPS Office open an Excel workbook after WEBSERVICE errors appear?

Yes, WPS Spreadsheets can open .xlsx workbooks and offers a free alternative for daily spreadsheet work, though you should verify whether specific WEBSERVICE or external data features behave the same in your file.