Forum Discussion

jlokatys's avatar
jlokatys
Copper Contributor
Oct 26, 2021

Excel deleted tabs & data after saving file

I have an Excel worksheet that has 3 tabs. After saving my work, when I go back into the file now I only have 1 tab and missing data. The data from tab #3 is now on tab #1. And much of the information that should be on tab #1 is missing. Tab 2 & 3 are completely gone. I am positive I saved my work because this happened before so now I am being very careful. There are no older versions of the file to recover. 

Thank you for any suggestions you may have. 

4 Replies

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor

      postcarter Did you perhaps save the file as a CSV? If so, only the active sheet is saved and all formulas and formats are removed. Only values are saved.

      • postcarter's avatar
        postcarter
        Copper Contributor
        Come to think of it, I am sure it was a CSV file to which I added the tabs - though I then saved as under a different name, I think it had the tabs when I saved and closed it the last time. Damned irritating either way. Thanks for taking the time to reply, I'll go start re-doing my tax return spreadsheet...

Resources