Fix Excel WEBSERVICE #VALUE! After a Python in Excel Update
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.

- 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.
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.
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.
Open Excel and click File > Account > About Excel to verify that you are on Version 2311, Build 17005.20000 or later.
Click File > Account > Update Options > Update Now, then restart Excel after the update completes.
Open the affected workbook, click File > Options > Trust Center > Trust Center Settings > External Content, and choose to enable data connections for this workbook.
Select the formula cell and click Formulas > Calculate Now to confirm the #VALUE! error is replaced by the expected web response.

Temporary VBA Workaround with MSXML2.ServerXMLHTTP
Use this when you cannot install the Excel update immediately and your security settings allow VBA macros.
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. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free to get the latest version.
- 2. Install and open WPS Spreadsheets: Run the installer, open WPS Spreadsheets from the WPS Office home screen, and sign in if needed.
- 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.

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.




