Forum Discussion
OPENED FILE AND ALL CHARTS WERE MISSING
So, I have been using this spreadsheet since 2014 and have always upgraded it to stay current. I had a file in Jan 2024 that I added data to and saved. Last month (Apr), I opened the file to add new ...
Check for Hidden Objects or Sheets
Sometimes charts might be hidden rather than deleted.
Unhide Sheets: Go to the Sheet tab at the bottom of Excel, right-click, and select Unhide to ensure no sheets were hidden.
Check for Hidden Objects: Charts might be moved or hidden behind other objects. Use Find & Select to locate hidden objects:
Go to Home > Find & Select > Selection Pane. This pane allows you to see all objects on the sheet and unhide them.
Sometimes charts might be hidden rather than deleted.
Unhide Sheets: Go to the Sheet tab at the bottom of Excel, right-click, and select Unhide to ensure no sheets were hidden.
Check for Hidden Objects: Charts might be moved or hidden behind other objects. Use Find & Select to locate hidden objects:
Go to Home > Find & Select > Selection Pane. This pane allows you to see all objects on the sheet and unhide them.