Forum Discussion
How to recover an excel file with format and details that are wrongly save as CSV format?
Hi Would like to check out is there any way to recover and excel file with format and details that are wrongly save as CSV format. The orginal raw file is a CSV format but had done some tabulation ...
I did the same think. Hours of work wasted. I did learn a valuable lesson so I guess it was worth it. I do wonder why the other tabs were even permitted without a prompt to change the format to save it. It is a fault for some program I think. I was on the alternate tab when I saved it so I would think it shoud be somewhere!
Rhonda910 I just did the same thing and lost all the data on other tabs.
To help avoid this in the future, in Excel go to File > Options > Save under Save workbooks, and check "Show data loss warning when editing comma delimited file (*.csv)"
Now when I open a csv file I get this warning:
- Maybe it was the default, and I turned it off. ??
Thank you for this! Maybe it will save me in the future. I wish that were the default setting.
