Excel Data Suddenly Lost!

aaronnechama

New Member
Joined
Mar 11, 2009
Messages
6
I made some changes to an excel file (added a new sheet, changed the order and numbers on first sheet) and when I opened the workbook today all the changes are lost! There is no reason for this happening - my data was successfully saved previously. Is there any way to restore the lost data? :confused:
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

aaronnechama

New Member
Joined
Mar 11, 2009
Messages
6
OK, I figured it out. There were TWO workbooks saved in that location with the same filename, one was .xls (97-2003) and the new one was saved as the default version .xlsx. When I opened the file, I was viewing the old .xls version and was not seeing the new .xlsx with the changes. I discovered this by searching for the filename and both files appeared.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,261
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top