Solved Excel only opens an old version of my document

November 26, 2012 at 09:37:48
Specs: Windows Vista

I have been working on an excel file (.xlx) for over a year, always saving the same file. Now I can only find the most recent version as of a month ago and not the my most recent save last week. Is there anyway to find my most recent save from last week?

See More: Excel only opens an old version of my document

Report •


✔ Best Answer
November 26, 2012 at 15:32:55

Check your Save Locations in Options.

Click the Microsoft Office button
Click on the Excel Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Save button in the left hand pane

In the Right side panel, you should see:

AutoRecover File Location:
Default File Location

Check both locations.

Two other possible locations are:

C:\Documents and Settings\username\My Documents
C:\Users\username\Documents

Also, are you sure you have the correct name?
If you come across files called "Book1" check them
also, as that is the default name Excel gives

MIKE

http://www.skeptic.com/



#1
November 26, 2012 at 09:50:14

P.S. This does not happen on any other Excel documents, just a critical one that I really would not like to redo a month's worth of work!

Report •

#2
November 26, 2012 at 12:03:14

I have been working on an excel file (.xlx)

A file with the extension of .XLX is an Xcelsius Crystal Reports file,
not an Excel file.

Do you mean an XLS file type?

In any case your question is confusing.

You first say:
always saving the same file

Then you say:
I can only find the most recent version as of a month ago and not the my most recent save last week

If the file has the same name all the time, you can have only one copy of it.
That copy will be the most recent.

Are you saving it to a different location each time you save?

Not sure what your problem is.

MIKE

http://www.skeptic.com/


Report •

#3
November 26, 2012 at 14:07:10

Thanks for taking your time, and I apologize for the confusion. Let me try again...
It is a 2007 excel file (.xlsx; not .xlx file) a typo!

I have been working on the same document each time. I have saved it and opened it again many times over the past month or so. Each time I open the latest version of the document and continue to edit and then save. The last input is always there when I open it again. Usually, I open it from one of the most recent documents in the list after I click on the office button in a blank excel document.

This time I had to open the document from my document files because I had been cleaning up old files and opened many more excel documents and lost the link in the recent documents tab.

When I did this, an old version from a month ago seems to be the most recently saved document. I searched for the document on the entire computer, but I only find the version from a month ago. I have always used the same name and location to save.

Hope this helps you understand my plight and hope that you may have some words of wisdom for me! Thanks.


Report •

Related Solutions

#4
November 26, 2012 at 15:32:55
✔ Best Answer

Check your Save Locations in Options.

Click the Microsoft Office button
Click on the Excel Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Save button in the left hand pane

In the Right side panel, you should see:

AutoRecover File Location:
Default File Location

Check both locations.

Two other possible locations are:

C:\Documents and Settings\username\My Documents
C:\Users\username\Documents

Also, are you sure you have the correct name?
If you come across files called "Book1" check them
also, as that is the default name Excel gives

MIKE

http://www.skeptic.com/


Report •

#5
November 27, 2012 at 06:32:35

Mega Thanks Mike, You saved me many hours of trying to duplicate my work. It was where you suggested, in the auto recover file location!

Report •


Ask Question