Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Excel incorporates Power Query (also called Get & Transform) technology to provide greater capability when importing, refreshing, and authenticating data sources, managing Power Query data sources, and shaping the data into a table that fits your requirements.  

You can refresh data sources on Excel for the web:

  • To refresh all data sources in a workbook, select Data > Refresh All Connections

  • To refresh all queries in the workbook, select Data Queries, and then in the Queries pane, next to n queries, select Refresh Icon for refresh operation.

  • To refresh a specific query, select Data Queries, and then in the Queries pane, next to the query name, select Refresh  Icon for refresh operation.

  • To refresh a specific query group, select Data Queries, and then in the Queries pane, next to the group name, select Refresh  Icon for refresh operation.

    To refresh a specific PivotTable connected to a query, select a cell in the PivotTable, and then select Data > Refresh Selected Connection.

For more information about supported data sources in Excel for the Web, see Power Query data sources in Excel versions

You can view your queries and related details in the Queries task pane. You can also perform various grouping tasks to better organize your queries. For more information, see Manage queries.

 

 

 

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×