Excel workbook automatically deleting or merging new sheets after saving?

%3CLINGO-SUB%20id%3D%22lingo-sub-2654553%22%20slang%3D%22en-US%22%3EExcel%20workbook%20automatically%20deleting%20or%20merging%20new%20sheets%20after%20saving%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2654553%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20workbook%20with%20one%20sheet%20full%20of%20a%20raw%20data%20output%20(%22RAW%22).%20Today%2C%20I%20tried%20adding%20another%20sheet%20for%20the%20formatted%20data%20(%22Cleaned%22).%20Everything%20seemed%20fine%20until%20I%20saved%20and%20closed%20the%20workbook%3B%20I%20saw%20that%20the%20file%20size%20went%20from%20like%20150%20KB%20to%207%20KB.%20After%20opening%20it%20again%2C%20all%20of%20my%20raw%20data%20is%20gone%2C%20and%20all%20the%20content%20of%20the%20new%20sheet%20I%20made%20(%22Cleaned%22)%2C%20minus%20formatting%2C%20is%20now%20in%20the%20%22RAW%22%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20reverted%20to%20an%20earlier%20version%20and%20re-created%20the%20%22Cleaned%22%20data%20sheet%2C%20saving%20it%20and%20closing%20the%20workbook%2C%20and%20the%20same%20thing%20happened%20again.%20What's%20going%20on%3F%20Every%20edit%20I%20make%2C%20regardless%20of%20how%20small%20(i.e.%20putting%20a%20%221%22%20into%20a%20new%20sheet%2C%20then%20saving%20and%20exiting)%20leads%20to%20the%20content%20of%20the%20new%20sheet%20replacing%20the%20old%20sheet%20under%20the%20old%20sheet's%20name.%20It'd%20be%20a%20real%20tragedy%20if%20I%20lost%20any%20data%2C%20so%20I'm%20a%20bit%20afraid%20to%20open%20my%20other%20workbooks.%20Any%20help%20would%20be%20really%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2654553%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2654582%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20workbook%20automatically%20deleting%20or%20merging%20new%20sheets%20after%20saving%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2654582%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1129974%22%20target%3D%22_blank%22%3E%40scconn101%3C%2FA%3E%26nbsp%3BAre%20you%20by%20any%20chance%20saving%20the%20file%20as%20.csv%20or%20.txt%3F%20It%20should%20give%20you%20a%20warning%20that%20you%20trying%20to%20use%20a%20workbook%20with%20multiple%20sheets%2C%20though.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaving%20a%20a%20regular%20Excel%20workbook%20(xlsx)%20should%20not%20remove%20sheets%20like%20you%20describe.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 workbook; I saw that the file size went from like 150 KB to 7 KB. After opening it again, all of my raw data is gone, and all the content of the new sheet I made ("Cleaned"), minus formatting, is now in the "RAW" sheet.

 

I reverted to an earlier version and re-created the "Cleaned" data sheet, saving it and closing the workbook, and the same thing happened again. What's going on? Every edit I make, regardless of how small (i.e. putting a "1" into a new sheet, then saving and exiting) leads to the content of the new sheet replacing the old sheet under the old sheet's name. It'd be a real tragedy if I lost any data, so I'm a bit afraid to open my other workbooks. Any help would be really appreciated.

2 Replies

@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!!