'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Web.BrowserContents Not Recognized in Excel Power Query
Question details
The user needs to resolve an issue where the Web.BrowserContents function in Excel Power Query works properly on Windows 10 but is completely unrecognized on a new Windows 11 device.
- Product
- Microsoft Excel (Microsoft 365)
- Device & OS
- Windows 11 and Windows 10
- Scenario
- Importing dynamic web data using Power Query M-code on a newly set up Windows 11 computer.
- Observed behavior
- The Power Query execution fails with a function not recognized error for Web.BrowserContents, despite both systems supposedly running current Microsoft 365 builds.
Ensure you have administrator privileges on your Windows 11 computer to update or repair Microsoft Edge WebView2 components and Microsoft 365 installations. Save a text backup of your Power Query M-code before modifying the environment.
Check and Align Microsoft 365 Build Versions
Verify that both computers are running the exact same Excel build, as newer Power Query functions may roll out incrementally to different update channels.
Even when two computers have an active Microsoft 365 subscription, they can be on different update channels (e.g., Current Channel vs. Semi-Annual Enterprise Channel). The Web.BrowserContents function may not be available in older builds.
Launch Microsoft Excel on both the Windows 10 and Windows 11 computers. Click on 'File' in the top left corner, then select 'Account' from the bottom left menu.
Look under the 'About Excel' section on both devices and note the exact Version, Build number, and Update Channel.
If the Windows 11 build is older or on a delayed channel, click 'Update Options' next to Office Updates and select 'Update Now' to force the system to download the latest features.
Repair Microsoft Edge WebView2 Runtime
Since Web.BrowserContents relies heavily on the WebView2 runtime to render dynamic web pages, repairing it on Windows 11 can resolve missing dependencies.
Try WPS Office for Seamless Spreadsheet Processing
If complex Excel Power Query dependencies like WebView2 runtime mismatches are disrupting your data workflow, consider WPS Office as a lightweight, free Microsoft Office alternative. It provides high compatibility with Excel files, a familiar user interface, and smooth data handling without requiring heavy, channel-specific environment configurations.
- 1. Download WPS Office: Visit the official WPS website to download the free installer.
- 2. Install and Open: Run the installer, then open WPS Spreadsheets.
- 3. Import Your Data: Open your existing .xlsx files directly and continue your data analysis tasks without compatibility issues.
Frequently Asked Questions
Why is Web.BrowserContents available on one computer but missing on another?
Microsoft releases Excel and Power Query updates across different channels. Even if both PCs have a Microsoft 365 license, one might be on the Current Channel while the other is on a delayed Semi-Annual Channel, meaning the newer function hasn't rolled out to the second computer yet.
What is the role of WebView2 in Excel Power Query?
The Microsoft Edge WebView2 runtime allows Office applications to embed modern web technologies. Power Query utilizes WebView2 to execute functions like Web.BrowserContents, which is necessary for rendering and scraping dynamic, JavaScript-heavy web pages.
Can I use Web.Page instead of Web.BrowserContents as a workaround?
Yes, you can try replacing Web.BrowserContents with the older Web.Page function in your M-code. However, Web.Page uses the legacy Internet Explorer engine, which may not successfully load or extract data from modern websites.
How do I check my Power Query version?
Power Query is built directly into Microsoft Excel. You can check the version by opening Excel, clicking 'File', selecting 'Account', and checking the 'About Excel' section. The Power Query engine version matches your Excel build.
