Data Import & Export

Refresh SQL and Web API Connections in Excel for the Web

Amos GikundaAmos Gikunda Nov 18, 2026 868 views

Question details

Refresh SQL or web API data in a workbook opened in Excel for the web.

Refresh SQL and Web API Connections 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.
Before you start

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.

Solution 1Recommended

Refresh the connection in desktop Excel

Use desktop Excel when the connection requires a locally installed driver or another desktop-only component.

1
Open the workbook in Excel

In Excel for the web, select Open in Desktop App from the editing or Open menu.

2
Check the connection

In desktop Excel, select Data > Queries & Connections and inspect the query. Install the required driver and configure the data source and credentials if needed.

3
Refresh the data

Select Data > Refresh All, then check the query for errors and verify the updated values.

4
Save the workbook

Select File > Save to update the workbook in OneDrive or SharePoint, then reopen it in Excel for the web to view the refreshed data.

Refresh the connection in desktop Excel
Desktop requirements: The computer running Excel must be able to reach the source and have the required driver, provider, and credentials.
Free Microsoft Office alternative

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.

Open and edit spreadsheet data, including previously refreshed valuesCompatible with Microsoft Excel XLSX and XLS filesFamiliar spreadsheet interface for easier migrationFree and lightweight for everyday office tasks
microsoft office alternative - wps office

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.