Link to home
Start Free TrialLog in
Avatar of Optima Systems
Optima SystemsFlag for United Kingdom of Great Britain and Northern Ireland

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\Application Data\Microsoft\Excel\
Default file location C:\Documents and Settings\CraigS\My Documents
ASKER CERTIFIED SOLUTION
Avatar of Elton Pascua
Elton Pascua
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Optima Systems

ASKER

the shared file is causing the problem
It was a problem with Excel 2010 opening a shred spreadsheet.
Avatar of imtt321
imtt321

is there a solution to this issue.  This is the exact same problem I am having, and this post has only identified the issue.
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.
So this boils down to a corrupt file that Office can't properly back up?