Fix Excel VBA Charts Not Refreshing After an Office Update
Question details
An Excel user needs charts to refresh when a VBA form updates their source data.

- Product
- Microsoft Excel for Office
- Device & OS
- not provided
- Scenario
- A VBA form changes data used by charts after an Office update.
- Observed behavior
- The charts do not visibly refresh until the form closes and the user clicks a chart.
Identify the worksheet, chart name, and source range used by the form. In Excel, check File > Account for the installed Office version and build number.
Calculate the source data and refresh the chart in VBA
Use an explicit calculation and chart refresh after the form writes its changes.
In Excel, open Formulas > Calculation Options and select Automatic. If the workbook requires manual calculation, keep that setting and explicitly calculate the affected sheet in your code.
Open the VBA editor with Alt+F11, then locate the form procedure that writes the new chart data.
After the data-writing code, add: ThisWorkbook.Worksheets("Sheet1").Calculate: ThisWorkbook.Worksheets("Sheet1").ChartObjects("Chart 1").Chart.Refresh. Replace Sheet1 and Chart 1 with your worksheet and embedded chart names, and use the appropriate workbook reference if the chart is elsewhere.
If the form changes the size or location of the source range, select the chart and open Chart Design > Select Data to verify its source. Update the chart's source range in VBA if it needs to change dynamically.
Run the form again, update the data, and check whether the chart redraws before the form closes.

Update Office or request a supported rollback
Use this approach if the problem began after an Office update or continues after the VBA refresh changes.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move everyday spreadsheet work. It does not repair Microsoft Excel's VBA chart-refresh behavior, and macro compatibility depends on the WPS edition and platform.

Frequently Asked Questions
Why does my chart update only after I click it?
The source data may have changed without the chart visibly redrawing. After the form writes the data, calculate the affected worksheet and call Chart.Refresh, then test whether the chart updates while the form is open.
Where do I turn on automatic calculation in Excel?
Open Formulas > Calculation Options and select Automatic. If your workbook relies on manual calculation, explicitly calculate the affected worksheet in VBA instead.
How do I find my Office build number?
In Excel, open File > Account and look under Product Information. Include the version and build number when reporting the issue to Microsoft or your IT administrator.
What if the chart's source range changes size?
Select the chart and open Chart Design > Select Data to inspect its source. If the form changes the source range dynamically, update the chart's source range in VBA before refreshing the chart.
Will WPS Office fix Excel's VBA chart refresh issue?
No. WPS Office is an alternative for spreadsheet work, not a fix for an issue inside Microsoft Excel. Check macro support and compatibility for your WPS edition and platform before relying on an existing VBA workbook.




