Excel 2016 cannot open files containing charts or insert new charts

Last Updated: April, 2019

ISSUE

After the March release, some people using languages other than English are reporting error opening files containing charts or inserting new charts. We are currently investigating the issue and working to resolve it. The workaround below has resolved the problem for some people:

STATUS: WORKAROUND

Workaround part 1: change operating systems region and regional format briefly to a different setting then back to the original settings
Steps:

  • Close all Excel windows

  • Select the Windows button

  • Choose Settings

  • Open Time and Language (Time, Language may also be separate selection depending on your Operating System)

  • Choose Region

  • Change the “Country or region” drop-down to “United State” (remember the original setting so you can change back later)

  • Change the “Current format” drop-down to “English (United States) (remember the original setting so you can change back later).

Note: If your Windows doesn't have this session, you can go to Control Panel->Clock Language and Region->Region->Formats, and change it to English (United States).

  • Verify insert chart works.

  • After the steps above are completed, please close Excel and change your regional settings back to you preferred settings and try creating your chart again.

Workaround part 2: install English language pack to your Office.

Steps:

  • First, you need to know if you have 32-bit office or 64-bit office

    • Start Excel

    • File menu -> Select Account

    • Choose About

    • In the displayed dialog box, there is a line that ends in either 32-bit or 64-bit. This is the information that will be used later.

    • Close the About dialog

  • File->select Options

  • Choose language

  • Select the hyperlink "Get more display and Help languages from Office.com"

  • Scroll down on the site to step one and select “English” from the drop-down that says “What language do you need?”

  • Select the download link that matches your install for 32-bit or 64-bit and follow the instructions to install the language pack.

More Resources

Icon Experts (brain, gears)

Ask the experts

Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.

Excel Tech Community

Icon Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Excel Forum on Answers

Icon feature request (light bulb, idea)

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Excel UserVoice

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×