Forum Discussion
Solved
Excel workbook automatically deleting or merging new sheets after saving?
I have an Excel workbook with one sheet full of a raw data output ("RAW"). Today, I tried adding another sheet for the formatted data ("Cleaned"). Everything seemed fine until I saved and closed the ...
scconn101 Are you by any chance saving the file as .csv or .txt? It should give you a warning that you trying to use a workbook with multiple sheets, though.
Saving a a regular Excel workbook (xlsx) should not remove sheets like you describe.
scconn101 Are you by any chance saving the file as .csv or .txt? It should give you a warning that you trying to use a workbook with multiple sheets, though.
Saving a a regular Excel workbook (xlsx) should not remove sheets like you describe.
That solved it, thank you so much! The raw data output file was a .csv and I didn't get the warning, for some reason. Really appreciate your help!!