Fix Missing or Disabled Excel Charts After the Office 2016 Update
Question details
Restore Excel chart options and existing charts that disappeared after an Office update.
- Product
- Microsoft Excel in Office 2016
- Device & OS
- Windows; version not provided
- Scenario
- An Office installation was updated from version 1902 to version 1903.
- Observed behavior
- Chart options are disabled and existing charts are not visible on computers running version 1903, while systems on version 1902 are unaffected.
In Excel, open File > Account to check the Office version, update channel, and installation type. The command-line method below applies to Click-to-Run installations and requires administrator access; contact your IT administrator if Office updates are managed by your organization.
Change the Office update channel and run an update
Use this reported fix when version 1903 disables Excel charts and Office is on the Monthly update channel.
The original fix switched Office from the Monthly channel to the Broad channel and installed an update. Channel names and availability have changed since Office 2016, so this legacy command may not work with your current configuration.
In Excel, select File > Account and review the Office version and update channel under Product Information. If your organization controls the channel, ask its administrator before changing it.
Open the Windows Start menu, search for Command Prompt, select Run as administrator, and approve the prompt.
Enter `cd /d "C:\Program Files\Common Files\Microsoft Shared\ClickToRun"` and press Enter. If the folder is not found, check whether it is under `C:\Program Files (x86)\Common Files\Microsoft Shared\ClickToRun` instead.
Run `OfficeC2RClient.exe /changesetting Channel=Broad`, then run `OfficeC2RClient.exe /update user`. Allow the Office update to complete.
Restart the computer, open the affected workbook in Excel, and check whether existing charts appear and Insert > Charts options are available.
Update or repair the Office installation
Try a supported update or repair if the legacy channel command is unavailable or charts remain missing.
Open and edit spreadsheet charts with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format support for moving between applications. WPS Spreadsheets can open workbooks and work with charts, although complex chart formatting may vary.

Frequently Asked Questions
How do I check which Office version and update channel I have?
In Excel, select File > Account and look under Product Information. The displayed version and channel details depend on your Office installation.
Why are my Excel chart options disabled after version 1903?
The reported issue appeared after the version 1903 update, while computers on version 1902 were unaffected. An Office update or channel change resolved the issue in the reported case, but other causes are possible.
Can I use the Broad channel command on every Office installation?
No. The command was reported for a Click-to-Run installation, and Broad is a legacy channel name. Availability and organizational update policies can prevent the change.
What should I do if updating Office does not restore my charts?
Try repairing Office from Windows Settings > Apps > Microsoft Office > Modify, then reopen the workbook. If charts are still missing, contact Microsoft Support or your Office administrator.




