Recover sheets

[CHML]

Hi all.

I downloaded a report from a company with this version

and I added another 3 sheets, then tried to save it. It gave me the message bellow;

Not really looking at the content of message, I clicked OK and then exited out the file when asked if save changes, I clicked on SAVE and then noticed the poncher; only one sheet was saved and all other literaly disapeared! I worked hours & hours on this, I wish I can recover them! Looking forwardfor advise. Thank you.

 

[Joe4]

That is a bit misleading, as Excel and CSV file are two very different things. You can use Excel to open a CSV file, but it will do its own automated conversions on it.
A CSV file is absolutely NOT a Spreadsheet! It is a Text file.
Like every other Text, it is a "flat" file, meaning it is only one page. You cannot have multiples pages in a CSV file!

If you are working on a file in Excel that has multiple sheets, when you save it, you MUST select an Excel option if you want to maintain your multiple pages.
If you choose to save to a CSV, you will only save the sheet that you are on.

That is what the warning message was telling you. Whenever you get them when trying to save a file, you should read them very carefully so as not to lose any data.

 

[CHML]

Right, and thank you!. So I guess no recovery?

 

[rlv01]

and I added another 3 sheets, then tried to save it. It gave me the message bellow;

After you added the other three sheets, you can do a File 'Save-A's to save it to a standard spreadsheet file (.xlsx) unless there is a reason to keep it as a .csv file?

 

[CHML]

No reason. Going forward, I will know already. My question was if by now there's still anything to do? otherwise, I'll start from scratch.

 

[Joe4]

So I guess no recovery?

None that I know of, unless you automated backups running.

 

[rlv01]

My question was if by now there's still anything to do? otherwise, I'll start from scratch.

Probably not. Sorry. (We've all been there, btw).

 

[CHML]

Ok, Thank you to all of you.