Forum Discussion
jlokatys
Oct 26, 2021Copper Contributor
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 informatio...
Riny_van_Eekelen
Jan 02, 2024Platinum 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
Jan 02, 2024Copper 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...