Optima Systems
asked on
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\Applicatio n Data\Microsoft\Excel\
Default file location C:\Documents and Settings\CraigS\My Documents
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\Applicatio
Default file location C:\Documents and Settings\CraigS\My Documents
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It was a problem with Excel 2010 opening a shred spreadsheet.
is there a solution to this issue. This is the exact same problem I am having, and this post has only identified the issue.
ASKER
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.
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.
So this boils down to a corrupt file that Office can't properly back up?
ASKER