I have a large Excel 2013 spreadsheet with 20 tabs, and some very simple data and some graphs.
This spreadsheet is edited every monday by several people as they enter their department's weekly summary data.
Yesterday when I opened the spreadsheet and all the tabs were gone. There was not even a blank tab, just a blank area under the ribbon/menus.
The small amount of VBA code in this file is still visible.
This has happened 2 or 3 times before over the last few years. When it happens, I retrieve a recent backup and ask people to look up their last couple weeks' data to re-enter.
The file size is the same as before. I suspect that all the information for each of the tabs is still stored in the file, but for some reason it won't/can't display the tabs.
Just wondering if anyone know what causes this problem, and if there is a way to force it to show the tabs that I believe are still there.
Bookmarks