Fix Excel Charts That Do Not Refresh and PivotChart Copying Crashes
Question details
The user needs Excel charts to update after a Power Pivot refresh and to copy PivotCharts without crashing Excel.

- Product
- Microsoft Excel with Power Pivot
- Device & OS
- not provided
- Scenario
- Refreshing charts created from Data Model tables or copying and pasting a PivotChart.
- Observed behavior
- Charts may not reflect refreshed data, and Excel may crash when a PivotChart is copied or pasted.
Check that the workbook's data sources are accessible and note which chart and refresh or copy action trigger the issue. In Excel, check File > Account for the product version and update options, if available.
Update Excel and refresh the affected PivotChart
Use this first to rule out an outdated Excel build or an incomplete refresh.
In Excel, open File > Account > Update Options > Update Now, if available. If your organization manages updates, ask your administrator to install the latest available build.
Open the affected workbook and select Data > Refresh All. Wait for the data connections to finish refreshing.
Select the PivotTable associated with the affected PivotChart, then choose PivotTable Analyze > Refresh. Check whether the chart reflects the updated data.
Select the PivotChart, use Copy, and paste it into a worksheet to check whether Excel still crashes.

Test a new workbook and recreate the Data Model chart
Use a fresh workbook to determine whether the issue is specific to the original workbook or chart.
Disable add-ins, repair Microsoft 365, and report persistent crashes
Use this if the problem continues after updating Excel and testing a new workbook.
Work with spreadsheet charts in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Microsoft Office files. Use WPS Spreadsheets for everyday data and charts as you migrate compatible workbooks. It does not repair Excel crashes, and complex Power Pivot models or PivotCharts may not behave the same way.

Frequently Asked Questions
Why does my Excel chart still show old data after a refresh?
The source connection or associated PivotTable may not have finished refreshing. Select Data > Refresh All, wait for completion, and then select the associated PivotTable and choose PivotTable Analyze > Refresh.
How can I tell whether the crash is specific to my workbook?
Create a blank workbook, connect to the same source data, and build a new Data Model and PivotChart. Refresh and copy the new chart to see whether the crash also occurs there.
Where do I check my Excel version?
In Excel, open File > Account and look under Product Information. Include the version and build details when reporting a reproducible issue to Microsoft.
Will WPS Office fix an Excel PivotChart crash?
No. WPS Office is an alternative spreadsheet application, not a repair tool for Excel. It can work with XLSX files and standard charts, but complex Power Pivot models and PivotCharts may not behave the same way.




