Excel Sheet Saved Wrong

Question

When I saved this file, it had three tabs. I saved it, closed it, & sent it to my manager. Now when we open it, there is only one tab with the title of tab one and the content of tab 2 & the other tabs are missing. There are no previous versions when I try to recover, even though I saved throughout.

Answer 1

Hi Anna Jelbert,

First, my pleasure to assist you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

As you mentioned, "There are no previous versions when I try to recover, even though I saved throughout" may I know where did you saved your problematic Excel file? If you confirm the file are stored in OneDrive for Business or SharePoint Online, you could check the methods below.

Check the version history, or SharePoint online version history of that workbook, see if the content could be retrieve.

Meanwhile, may I know does issue happened do specific Excel document?  If the issue happens to all Excel files including a new created one, the issue is more related to the Office app itself or your computer environment. You can first try suggestions below to see the result:

1. Make sure you’ve updated Office to the latest version that some issues can be resolved with such method.
2. Try open your Excel insafe mode which allow you to safely use it when it has encountered certain problems

In the meantime, to confirm whether this is a bug in a specific version, please provide us the version information. To check version: Open Excel>File>Account>Product Information and capture a full screenshot and share here (Please mask your private message for protecting your private message) and we will be tested on that version and verify the result with you.

I appreciate your understanding and stay safe!!

Best regards

Waqas Muhammad