'%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)
How to Refresh a Linked Excel Pivot Chart in PowerPoint
Question details
The user needs to know how to refresh a pivot chart embedded in a PowerPoint presentation that is linked to an external Excel workbook stored in OneDrive.
- Product
- Microsoft PowerPoint
- Device & OS
- not provided
- Scenario
- Updating a PowerPoint slide to reflect new data changes made to a linked Excel workbook stored on OneDrive.
- Observed behavior
- The PowerPoint pivot chart needs to actively sync and display the latest data adjustments from the linked Excel source.
Ensure that your linked Excel workbook is saved and fully synced to OneDrive, and verify that you have a stable internet connection to fetch the latest data updates.
Refresh the Linked Chart Data in PowerPoint
Use this standard method to manually trigger a data sync and update the pivot chart in your presentation after editing the source Excel file.
When an Excel pivot chart is pasted into PowerPoint with a data link, it relies on the source file to update its values. If the source workbook is modified in OneDrive, the chart in PowerPoint must be refreshed to display the new information.
Open your source Excel workbook in OneDrive, make the necessary data adjustments, and wait for the auto-save or manually save the changes.
Launch the PowerPoint presentation that contains the linked pivot chart you wish to update.
Right-click directly on the pivot chart within your slide and select 'Refresh Data' from the context menu.
If the chart does not update immediately, select the chart, navigate to the 'Chart Design' tab on the top ribbon, and click 'Edit Data'. This action forces PowerPoint to re-establish the connection to the Excel file and update the linked content.
Create and Refresh Linked Charts Easily in WPS Office
WPS Office offers a seamless, built-in way to link spreadsheet data directly to your presentations. You can effortlessly insert charts from WPS Spreadsheet into WPS Presentation and keep them perfectly updated with a single click.
- 1. Copy the Chart in WPS Spreadsheet: Open your data file in WPS Spreadsheet, select the generated chart you want to use, right-click it, and choose 'Copy'.
- 2. Paste with Link in WPS Presentation: Open your slide in WPS Presentation, click the drop-down arrow under the 'Paste' button on the Home tab, and select 'Keep Source Formatting & Link Data'.
- 3. Refresh Data Instantly: Whenever you modify your spreadsheet data, simply right-click the linked chart in WPS Presentation and select 'Refresh Data' to update the visuals instantly.
Frequently Asked Questions
Why is the Refresh Data option grayed out on my PowerPoint chart?
This typically occurs if the chart was pasted as a static image or a basic graphic rather than a linked object. It can also happen if the presentation has lost the path to the source Excel file because the file was moved, deleted, or renamed.
Can I link a chart without storing the Excel file in OneDrive?
Yes, you can link a chart to a local Excel file saved on your computer's hard drive. However, if you share the presentation or move it to another computer without also moving the source Excel file, the chart data will no longer be able to refresh.
How do I permanently break the link between my PowerPoint chart and Excel?
To stop the chart from updating and turn it into a static object, go to File > Info, click on 'Edit Links to Files' in the bottom right corner, select the specific Excel file link from the list, and click 'Break Link'.
Does refreshing the chart data also update my chart formatting?
Refreshing the data strictly updates the values, labels, and data series. Any formatting changes (such as colors, fonts, or chart styles) made in the Excel file will only carry over if the chart was originally pasted using the 'Keep Source Formatting & Link Data' option.
