Thursday, February 23, 2012

Microsoft Office Crashing When Editing Chart Titles

Wow, it's been 3 months since my last post.  I guess I'm not learning enough!  Well, that's not true.  It's been a busy time of moving to a new home, moving also to a new office, releasing a new software product, and crazy holidays.  It's fun!

Today's biggie is a result of changing my Boot Camp installation to Windows 7 x64.  After the complete redo of my Windows partition I had the strangest problem of Office 2007 crashing 100% of the time when I tried to edit the chart or axis title of a chart in Excel.  I think it also happened when editing text blocks in Paint.  Well after LOTS of searching, service pack installs, and many restarts I found this: Microsoft Technet

In summary this is all you need to do, and from what I read it affects Office 2007 and Office 2010 equally, for me it was only the x64 version, but you never know.

  • Open Control Panel
  • In view mode “View by Category”, find the section “Clock, Language and Region”
  • Click “Change Keyboards or other input methods”
  • Press the button “Change Keyboards”
  • Press the button “Add”
  • Scroll down to “English (United States)” and expand.
  • Check box “US”
  • Press OK.
  • Press OK. — You’ll see two keyboards listed “US” and “United States (Apple)”
  • Press OK.



18 comments:

  1. You sir are a bonafide genius. NOTHING else worked, including all of the pages of suggestions on the Microsoft forums. Thank you very much. :)

    ReplyDelete
  2. Agreed! Thank you for solving (and posting!) this solution!

    ReplyDelete
  3. Amazing. Have been unable to fix this for months. Thanks.

    ReplyDelete
  4. Not work with excel 2016 in mac, in El capitan latest version

    ReplyDelete
  5. Not work with excel 2016 in mac, in El capitan latest version

    ReplyDelete
  6. Yup it works, it worked for me. thanks who ever you are ....

    ReplyDelete
  7. You are a life saver. this worked like a miracle. Thanks a lot.

    ReplyDelete
  8. Good Day!
    It worked perfectly. you are the best . even microsoft coudn't help.

    ReplyDelete
  9. 7 years later and the solution still works just fine. Mans, you're a genius

    ReplyDelete
  10. I scoured through almost two dozen pages of Google and could not get a solution. Your solution worked perfectly. Windows 10, Office 2013, excel axes kept on crashing. But now all ok. Thank you for your effort in putting this together.

    ReplyDelete
  11. Sir you are a saviour...Thank you so much!

    ReplyDelete
  12. This type of message always inspiring and I prefer to read quality content, so happy to find good place to many here in the post, the writing is just great, thanks for the post. this

    ReplyDelete
  13. Thank you so so much! Your post was the only hint on the entire net that helped me (German) with an English laptop layout. The SAME error persists 2020 in Windows 10, Word/Excel 2013! when formatting graph axis, 100% of the time it instantly crashes. The same solution is necessary: apply English (US) language with any keyboard (US, German), and then it works again.
    Thank you so much man. This has been a bother over two projects for me.

    ReplyDelete
  14. ANOTHER SOLUTION !!!
    My problem was that Excel 2010 and 2013 keep on crashing any time I try to FORMAT AXIS on a chart.
    Solution: Go to Excel Options (File -> Options) and under the Advanced tab check the "Disable Hardware Graphics Acceleration" option. This solves the problem.
    In fact, after solving the problem the first time, subsequently, when I unchecked this option, the problem did not come back. Even when I uninstalled the Office 2013, and then installed Office 2010, the problem did not appear again.

    ReplyDelete
    Replies
    1. Sorry, I have to make an addition to my post of yesterday.
      For some reasons I re-formatted my laptop today, and then installed Office 2010. I tried the solution I recommended in the above post, but it DID NOT WORK.
      I then tried changing languages as described by previous commentators, and IT WORKED!!! I therefore recommend that you first try the languages solutions first to this problem. However, when I did it, I did not use English US language, but English UK; and a second time (on another computer), I used a combination of both. I think once you fiddle with the Language settings, soon after the Excel will start to work properly (Formatting the axis). Regards.

      Delete