How to Fix Linked Excel Chart Not Updating in PowerPoint After Reopening
Question details
The user needs to keep a linked Excel chart updating automatically in PowerPoint after both files are closed and reopened.
- Product
- Excel and PowerPoint
- Device & OS
- not provided
- Scenario
- Sharing and embedding chart data between Excel and PowerPoint files stored on SharePoint.
- Observed behavior
- The linked chart updates fine while both files are open, but stops updating after being closed and reopened, with the 'Automatic Update' option unchecking itself.
Ensure both the source Excel file and the destination PowerPoint presentation are saved and synced to the same stable location (such as the same SharePoint directory) before applying the fix to prevent broken file paths.
Use Paste Special to Insert the Excel Chart Object
Bypass the default paste options and use Paste Special to insert the chart as a linked object. This ensures the update connection remains robust even after files are reopened.
Using the standard 'linked-data' paste icon can cause PowerPoint to lose its auto-update configuration when files are closed, particularly in network or SharePoint environments. Using the 'Paste Special' method creates a more reliable OLE (Object Linking and Embedding) connection.
Open your source Excel file, click on the chart you want to link, and press Ctrl+C (or right-click and select Copy) to copy it to your clipboard.
Navigate to the target slide in your PowerPoint file. On the ribbon, go to the Home tab, click the arrow under the Paste button, and select 'Paste Special'.
In the Paste Special dialog box, select the 'Paste Link' radio button, then highlight 'Microsoft Excel Chart Object' from the list and click OK.
Save and close both files, then reopen them. If prompted, click 'Update Links'. Go to File > Info > Edit Links to Files and verify that 'Automatic Update' is checked for your chart.
How to Link Spreadsheet Charts in WPS Presentation
WPS Office provides robust and stable cross-application data linking. You can easily insert a chart from WPS Spreadsheet into WPS Presentation and keep the data synchronized without losing your automatic update settings.
- 1. Copy the Source Data: Open your data in WPS Spreadsheet, select the chart you want to use, and copy it using Ctrl+C.
- 2. Use Paste Special: Switch to your slide in WPS Presentation, right-click on the canvas, and select 'Paste Special' from the context menu.
- 3. Link the Chart Object: Select the 'Paste Link' option, choose 'WPS Spreadsheet Chart Object', and click OK to embed the linked chart.
- 4. Maintain Data Sync: Any subsequent changes made in WPS Spreadsheet will automatically reflect in your WPS Presentation slide.
Frequently Asked Questions
Why does the 'Automatic Update' option turn off by itself in PowerPoint?
This usually occurs when charts are pasted using the standard linked-data paste icon rather than Paste Special. PowerPoint struggles to maintain the dynamic data path in SharePoint upon closure, causing the setting to revert to manual.
How do I manage all linked files and charts in my presentation?
You can view and manage all active external links by navigating to File > Info and clicking on 'Edit Links to Files' in the bottom right corner. This menu allows you to force an update, change the source file path, or toggle between Manual and Automatic updates.
Can I edit the chart's style after using the Paste Special method?
When a chart is pasted as a linked Microsoft Excel Chart Object, native PowerPoint formatting options are limited. To alter the chart's appearance, you should open the source Excel file, make your styling changes there, and allow the linked object in PowerPoint to update automatically.
What should I do if the 'Update Links' prompt doesn't appear when opening PowerPoint?
If you don't see the prompt, your security settings might be blocking external links. Go to File > Options > Trust Center > Trust Center Settings > External Content, and ensure the settings permit the automatic updating of document links.
