How to find lost worksheet after save a CSV file to a new file?

Question

Hello,

I have worked in a CSV file with multiple worksheets. When I clicked Save As to save it to a new file, I did not pay attention to the popup "the selected file type does not support workbooks that contain multiple". As a result, both the old CSV file and the new saved file have the last worksheet only. All other sheets disappeared.

Please, does anyone have a method to bring those sheets back?

Thanks,

Sammi

Answer 1

Hi,

I suggest you go to File- Options- Save- please check if you have enabled the option "AutoRecover file":

If you have checked the option, you can go to the AutoRecover file loction and find the AutoRecover file.

You can also refer to this article and check if it will help you:

https://support.microsoft.com/en-us/office/recover-an-earlier-version-of-an-office-file-169cb166-e7e2-438e-8f39-9a8927828121?ui=en-us&rs=en-us&ad=us

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.