Lost data?

%3CLINGO-SUB%20id%3D%22lingo-sub-1604058%22%20slang%3D%22en-US%22%3ELost%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604058%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Microsoft%20Office%20Professional%20Plus%202016.%3C%2FP%3E%3CP%3EI%20have%20a%20CSV%20file%20(I%20thought%20I%20saved%20my%20file%20as%20an%20.xlsx%20but%20I'm%20guessing%20I%20was%20mistaken).%3C%2FP%3E%3CP%3EIn%20this%20CSV%20file%20I%20had%20multiple%20tabs%2C%209%20to%20be%20exact.%26nbsp%3B%20They%20were%20all%20renamed.%3C%2FP%3E%3CP%3EI%20was%20working%20on%20this%20file%20for%209%20hours%20last%20Saturday%20(8%2F15)%20with%20numerous%20regular%20saves.%26nbsp%3B%20(All%20the%20time%20thinking%20it%20was%20a%20xlsx%20file.)%3C%2FP%3E%3CP%3EThe%20finished%20product%20was%20only%20219KB%20in%20size.%3C%2FP%3E%3CP%3EWhen%20I%20opened%20it%20today%20(8%2F21)%20only%20one%20tab%20(the%20first%20tab%20was%20present%20with%20data%20-%20and%20the%20data%20that%20was%20present%20wasn't%20even%20formatted%20correctly).%3C%2FP%3E%3CP%3EMy%20file%20was%20on%20a%20One-Drive.%3C%2FP%3E%3CP%3ELong%20story%20short.%26nbsp%3B%20How%20can%20I%20recover%20a%20previous%20save%3F%26nbsp%3B%20One%20of%20the%20last%20things%20I%20did%20before%20my%20final%20save%20was%20to%20take%20all%20the%20columns%20of%20data%20that%20were%20in%20the%20first%20tab%20(309%20columns)%20and%20separate%20them%20into%208%20other%20smaller%20tabs.%26nbsp%3B%20I'm%20guessing%20that%20if%20I%20can%20recover%20the%20file%20from%20before%20I%20started%20separating%20the%20309%20columns%20out%20I'd%20be%20good%20to%20go%20but%20I%20can't%20find%20a%20way%20to%20recover%20that%20(previous)%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605893%22%20slang%3D%22en-US%22%3ERe%3A%20Lost%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605893%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767076%22%20target%3D%22_blank%22%3E%40Soaty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20worked%20with%20file%20on%20OneDrive%20and%20especially%26nbsp%3B%20AutoSave%20option%20was%20switched%20on%2C%20you%20may%20expand%20this%20window%20clicking%20on%20arrow%20key%20at%20the%20right%20of%20file%20name%20in%20title%20bar%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20375px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214011i2E0E31B221C8F048%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eclick%20on%20version%20history%20and%20restore%20any%20one%20you%20wish.%20Alternatively%20you%20may%20open%20OneDrive%20online%20and%20check%20version%20history%20from%203%20dots%20menu%20at%20the%20right%20of%20the%20file%20name.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1617464%22%20slang%3D%22en-US%22%3ERe%3A%20Lost%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EI've%20tried%20the%20Version%20history%20option%20and%20it%20(only)%20goes%20back%209%20or%2010%20iterations.%26nbsp%3B%20All%20are%20the%20same%20and%20return%20the%20same%20damaged%20file.%26nbsp%3B%20I%20think%20my%20data%20is%20gone%20forever.%26nbsp%3B%20Thanks%20for%20trying%20to%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620831%22%20slang%3D%22en-US%22%3ERe%3A%20Lost%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767076%22%20target%3D%22_blank%22%3E%40Soaty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%20to%20hear%20that.%20In%20general%20OneDrive%20keeps%20up%20to%20500%20versions%20if%20only%20that%20limit%20wasn't%20changed%20by%20tenant%20admin.%20That's%20for%20business%20account%2C%20not%20sure%20about%20personal%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have Microsoft Office Professional Plus 2016.

I have a CSV file (I thought I saved my file as an .xlsx but I'm guessing I was mistaken).

In this CSV file I had multiple tabs, 9 to be exact.  They were all renamed.

I was working on this file for 9 hours last Saturday (8/15) with numerous regular saves.  (All the time thinking it was a xlsx file.)

The finished product was only 219KB in size.

When I opened it today (8/21) only one tab (the first tab was present with data - and the data that was present wasn't even formatted correctly).

My file was on a One-Drive.

Long story short.  How can I recover a previous save?  One of the last things I did before my final save was to take all the columns of data that were in the first tab (309 columns) and separate them into 8 other smaller tabs.  I'm guessing that if I can recover the file from before I started separating the 309 columns out I'd be good to go but I can't find a way to recover that (previous) version.

3 Replies

@Soaty 

If you worked with file on OneDrive and especially  AutoSave option was switched on, you may expand this window clicking on arrow key at the right of file name in title bar

image.png

click on version history and restore any one you wish. Alternatively you may open OneDrive online and check version history from 3 dots menu at the right of the file name.

@Sergei Baklan ,

I've tried the Version history option and it (only) goes back 9 or 10 iterations.  All are the same and return the same damaged file.  I think my data is gone forever.  Thanks for trying to help.

@Soaty 

Sorry to hear that. In general OneDrive keeps up to 500 versions if only that limit wasn't changed by tenant admin. That's for business account, not sure about personal one.