Autorecover has been disabled

Sparhawk

New Member
Joined
Sep 14, 2009
Messages
14
I have a very annoying problem with a single file. About 15-20 minutes after opening it, I get a pop-up message saying "An unexpected error has occurred. AutoRecover has been disabled for this session of Excel."

When I check in the Save options, the AutoRecover timer and location are greyed out and cannot be selected.

I don't think the issue lies with the network path, as the file is in M:\My Documents\Packaging and I can open files with longer and more complex names from the same location without any problems. The file in question is an xlsm file but, again, I can open other xlsm files from the same location without any issues.

I am using Excel 2007 on Windows XP (SP 3).

This is a particular problem as I want to convert the file into a template to send out across my company and I don't want to knacker everyone's AutoRecover.

Does anyone have any idea what is going on here?
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Matt Rogers

Well-known Member
Joined
Sep 23, 2011
Messages
1,030
Hi.

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

This type of error can occur if the file that you want to insert or you are trying to insert is located
on a network location and the full path to the file is too long.

To solve this issue try reduce the length of the path by making the folder names short or by changing
the location of the file that you want to insert before inserting it into Excel.

For an example: - Copy the file from the network which is nested to a local drive before you insert it into Excel.

http://www.techyv.com/questions/autorecover-has-been-disabled-session-excel
 

Sparhawk

New Member
Joined
Sep 14, 2009
Messages
14
I can open other files with longer and more complex names from the same folder with no trouble, it's just this one file that won't work properly.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,978
Messages
5,447,674
Members
405,462
Latest member
est1989

This Week's Hot Topics

Top