Excel Problem

In Excel 2010

The problem I have is that I am frequently (about once or twice a day) getting the message

An unexpected error has occurred. Autorecover has been disabled for this session of Excel.

Following which I am not able to access any of the options on Excel’s File ribbon until close all Excel books I have open and restart Excel.

Default auto-recovery setting used – every 10 minutes;
Auto-recovery file location C:\Documents and Settings\CraigS\Application Data\Microsoft\Excel\
Default file location C:\Documents and Settings\CraigS\My Documents
LVL 1
JayHineAsked:
Who is Participating?
 
Elton PascuaConnect With a Mentor Commented:
It might help to try to observe if a certain file causes this. Based on my experiences, aside from add-in issues and bad installation of Office, corrupt files give you that "Unexpected Error".
0
 
JayHineAuthor Commented:
the shared file is causing the problem
0
 
JayHineAuthor Commented:
It was a problem with Excel 2010 opening a shred spreadsheet.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
imtt321Commented:
is there a solution to this issue.  This is the exact same problem I am having, and this post has only identified the issue.
0
 
JayHineAuthor Commented:
Hi
The spreadsheet was a very large one with lots of formula's and multiple sheets and also linked with other spreadsheets.

It turned out that as this was also a shared spreadsheet the 2003 version kept locking up. We upgraded to Excel 2010 and the problem resolved itself.

I hope that helps.
0
 
imtt321Commented:
So this boils down to a corrupt file that Office can't properly back up?
0
All Courses

From novice to tech pro — start learning today.