After upgrading to office 2016, some excel files crash.

Kacey Fern
Kacey Fern used Ask the Experts™
on
Greetings Experts,

I recently upgraded some of my computers to Office 2016.  

I’m noticing that some excel files crash while using them.  
Get a very broad error in the event viewer:  Event id: 1000:  faulting application name excel.exe version 16, time stamp xxxxxx

So no clue there.
If I take the file, I can open it in Excel 2010 without issue.
If I go to another computer with 2016, it crashes.  

So it’s something to do with the version.  

I copied the data from the worksheet to a new file, same thing, crashed when you go to edit data.

One of the files has a cell with the input:  ‘December 2015  
If I go to edit it to say, ‘January 2016    it crashes
If I go to another cell on the sheet, then I can edit certain cells without it crashing.

Very strange.  Font?  

Any ideas would help.  Thank you in advance for your efforts.

My best-
Kacey
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
please try to open same excel file that crashes in the safe mode, please see how to activate safe mode in the below link from microsoft.

it also shows other ways to troubleshoot the crash

https://support.microsoft.com/en-us/kb/2758592
Kacey FernSystem Engineer

Author

Commented:
excel.exe /safe is not working.
Get an error:
sorry, we couldn't find safe.xlsx.  is it possible it was moved.

Any idea why?
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
try /s to start Excel in Safe mode

Command-line switches for Excel
https://support.office.com/en-za/article/Command-line-switches-for-Excel-321cf55a-ace4-40b3-9082-53bd4bc10725

Also, be sure you have set up Trusted Locations and other defaults
Announcing the Winners!

The results are in for the 15th Annual Expert Awards! Congratulations to the winners, and thank you to everyone who participated in the nominations. We are so grateful for the valuable contributions experts make on a daily basis. Click to read more about this year’s recipients!

Kacey FernSystem Engineer

Author

Commented:
The /s wouldn't work either.  I was able to hit the ctrl button and start excel to initiate safe mode, but received an error.  I'll include the screen shot.  I hit fix now and nothing happens.
I ran the online repair for office and this is still happening.  Any ideas?
safe-mode-error.jpg
Remote Training and Programming
Top Expert 2015
Commented:
do you have more than one version of Office installed?

if so, perhaps uninstall both versions and then reinstall 2016
Kacey FernSystem Engineer

Author

Commented:
It was a new build, so only office 2016.  So you think I should just uninstall and reinstall?
Kacey FernSystem Engineer

Author

Commented:
Uninstalling now.  Will update once I have it reinstalled and patched.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
be sure to reboot after uninstalling
Kacey FernSystem Engineer

Author

Commented:
Uninstalled, rebooted and installed again.  worked.  Very strange how the same file didn't work on two separate machines, then worked after the reinstall.  Anyway, problem solved.  thank you.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
you're welcome, kacey ;) ~ happy to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial