Chart & Visualization Issues

Fix Excel Charts That Do Not Refresh and PivotChart Copying Crashes

Phi Hung VoPhi Hung Vo Nov 18, 2026 869 views

Question details

The user needs Excel charts to update after a Power Pivot refresh and to copy PivotCharts without crashing Excel.

Fix Excel Chart Refresh Issues and PivotChart Copying Crashes
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.
Before you start

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.

Solution 1Recommended

Update Excel and refresh the affected PivotChart

Use this first to rule out an outdated Excel build or an incomplete refresh.

1
Update Excel

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.

2
Refresh the workbook

Open the affected workbook and select Data > Refresh All. Wait for the data connections to finish refreshing.

3
Refresh the PivotTable

Select the PivotTable associated with the affected PivotChart, then choose PivotTable Analyze > Refresh. Check whether the chart reflects the updated data.

4
Test copying

Select the PivotChart, use Copy, and paste it into a worksheet to check whether Excel still crashes.

Update Excel and refresh the affected PivotChart
Free Microsoft Office alternative

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.

Create and edit standard spreadsheet chartsOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interface for everyday workGet a free, lightweight Office alternative
microsoft office alternative - wps office

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.