Lost Excel Tabs

Question

Hi, my husband has been working for hours on an excel spreadsheet with around 20 tabs.  Today he copied the text in one of the tabs to email to colleagues, hit save and closed the spreadsheet down.  When re-opened there was only the tab from where he had copied the data, all other tabs had disappeared.  We've noticed that the document is now saved as a cvs document.  He never changed it to a cvs file and had no warning when he closed the spreadsheet down.

Is there any way to recover the tabs which have gone missing?

Cheers

Answer 1

Hi Hilary,

I experienced the same issue on April 9 (AEST).

Via SharePoint Online, I worked on multiple Excel sheets one at a time over the course of the day. 

I prompted the Excel WebApp to open the sheets in Excel, and worked on the sheets as per normal, splitting my data into tabs. 

Excel looked like it was syncing my saves.

Unfortunately, when I closed my files and then went back later to view them - all the new tabs were gone. This was for 5 different spreadsheets.

I checked the version history, and while a new version was created, when I previewed them it didn't contain the separated tabs.

Answer 2

Hi Dave, thanks for such a prompt response.  Unfortunately the document is not in the original saved location, just the Excel csv file.

Any other ideas would be much appreciated?

Thanks, Hilary

Answer 3

Hi Hilary

In Windows File Explorer or on OneDrive check in the original save location and also where that CSV file is located for the original xlsx file, that should still exist, saving an Excel file as a csv would not overwrite the original file . . .

If you still cannot locate the original file, please let me know . . .