To change the data source of a PivotTable to a different Excel table or a cell range, click Select a table or range, and then enter the first cell in the Table/Range text box, and select OK

You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog …

You can view and manage data source credentials for the Power Query queries in your workbook in Excel for the Web using Data Source Settings. There are multiple actions you can do within …

After you create a chart, you can change the data series in two ways: Use the Select Data Source dialog box to edit the data in your series or rearrange them on your chart.

Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.

To change any source data that you associate with a workbook, use the tools in Power Pivot to edit connection information, or update the definition of the tables and columns used in your …

To change the data source of a PivotTable to a different Excel table or a cell range, click Select a table or range, and then enter the first cell in the Table/Range text box, and select OK

Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.

To edit data in PowerPoint, select Edit Data. This will open a window from your spreadsheet. Note: If the workbook you're working with has special startup requirements, such as enabling …

Learn how to update the data in an existing chart from its source. Edit a chart in Excel, create a chart from a table, and update a chart source.