Refresh SQL and Web API Connections in Excel for the Web
Question details
Refresh SQL or web API data in a workbook opened in Excel for the web.

- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- A workbook stored in OneDrive or SharePoint contains external data connections that need updated data.
- Observed behavior
- Excel for the web generally cannot refresh connections that depend on local ODBC drivers or desktop-only providers.
Identify the connection type and check whether it requires a local ODBC driver, desktop provider, or credentials. Confirm that you have access to the data source and permission to edit the workbook in OneDrive or SharePoint.
Refresh the connection in desktop Excel
Use desktop Excel when the connection requires a locally installed driver or another desktop-only component.
In Excel for the web, select Open in Desktop App from the editing or Open menu.
In desktop Excel, select Data > Queries & Connections and inspect the query. Install the required driver and configure the data source and credentials if needed.
Select Data > Refresh All, then check the query for errors and verify the updated values.
Select File > Save to update the workbook in OneDrive or SharePoint, then reopen it in Excel for the web to view the refreshed data.

Try refreshing a supported connection in Excel for the web
Use the browser refresh command when the workbook's connector and authentication method are supported.
Plan a cloud refresh with a supported service
Use a cloud service for scheduled updates when its connector, licensing, and access requirements support your source.
Work with Excel-compatible spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for opening and editing spreadsheet files in a familiar interface. It supports common Microsoft Office formats for an easier transition, but it does not fix Excel for the web connection limitations.

Frequently Asked Questions
Can Excel for the web refresh an SQL connection that uses a local ODBC driver?
Generally, no. Open the workbook in desktop Excel using Open in Desktop App, refresh it with Data > Refresh All, and save it back to OneDrive or SharePoint.
Can I refresh a web API query in the browser?
It depends on the connector, authentication method, and Microsoft 365 environment. Try Data > Refresh All in Excel for the web; if the connection is unsupported, refresh it in desktop Excel.
Will a Power BI scheduled refresh update my Excel workbook?
Refreshing a Power BI dataset does not automatically refresh the workbook's own queries. You need a workflow that explicitly writes updated data to the workbook, or you can use the refreshed Power BI dataset for a separate report.
When do I need an on-premises data gateway?
A gateway may be needed when a cloud service must access a supported data source on a private network. Check the connector's requirements in Power BI or Power Automate before configuring the gateway.




