VBA & Macro Problems

Fix Excel VBA Charts Not Refreshing After an Office Update

Steven ParkerSteven Parker Nov 18, 2026 869 views

Question details

An Excel user needs charts to refresh when a VBA form updates their source data.

Fix Excel VBA Charts Not Refreshing After an Office Update
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.
Before you start

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.

Solution 1Recommended

Calculate the source data and refresh the chart in VBA

Use an explicit calculation and chart refresh after the form writes its changes.

1
Check calculation mode

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.

2
Find the update procedure

Open the VBA editor with Alt+F11, then locate the form procedure that writes the new chart data.

3
Calculate and refresh

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.

4
Check the chart source

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.

5
Test the form

Run the form again, update the data, and check whether the chart redraws before the form closes.

Calculate the source data and refresh the chart in VBA
If the chart still does not redraw: An explicit refresh may not resolve every display issue introduced by an Office build. Check for a newer Office update and report the reproducible behavior if it persists.
Free Microsoft Office alternative

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.

Create and view spreadsheet charts in WPS SpreadsheetsOpen and save common Microsoft Excel formats such as XLSXUse a familiar interface for a smoother transition from ExcelWork with a free, lightweight office suite
QA img-9

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.