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. 

excel

4 Replies

Sort By
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jan 02, 2024

      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
        Jan 02, 2024
        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