Recover lost excel tabs/spreadsheets from workbook

J

J&L

Have an excel workbook with multiple spreadsheets. For reasons unknown all
the tabs have disappeared from the workbook except for one. I know they are
still in the workbook, however, because the document size has not changed.
Somehow, the tabs containing the balance of my spreadsheets in this workbook
are just not displayed.

How can these lost tabs be recovered?
 
D

Dave Peterson

First, can you see any of the worksheet tabs?

If yes, are you sure you haven't scrolled too far in one direction to see the
others? Maybe using the VCR/DVR controls to the left of the sheettabs will
allow you to see more?

In fact, if you right click on those VCR/DVR controls, you should see a list of
sheets that you can select from. Do you see the extra sheet names there?

ctrl-pgup, ctrl-pgdn are short cut keys to loop through the visible sheets. If
you click on those shortcut keys, do you see more sheets?

=========
If you can't see the tabs, could you still cycle through the visible sheets
using the shortcut keys?

If yes, then the tabs maybe off the screen or could be turned off.

In xl2003, I can use:
Window|Arrange|Tiled (and then maximize the window I want) to make sure I can
see everything.

And I can toggle the view of the tabs by:
Tools|Options|view tab|Check (or uncheck) Sheet tabs

===========
If you can't cycle through them and you can see the tabs, the sheets could still
be hidden.

In xl2003 menus, I can use:
Format|sheet|unhide
to see the sheets that are hidden (but not necessarily all the sheets!)

Developers can mark sheets as VeryHidden. This means that the names won't
appear in that Format|sheet|unhide dialog.

So you'll have to do more work.

Open excel.
Open your workbook.
Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-r to see the the project explorer (like windows explorer)
Locate your workbooks project and expand the objects in that project. (Just
keep clicking the + sign on the left hand side -- like you do in windows
explorer to see all the subfolders.)

Under the "Microsoft Excel Objects" branch, you'll see all the sheets that are
in your workbook.

Click on any of the sheets you don't see in excel.
Hit F4 to see the properties window.
Look for the Visible property.
Make it "-1 - xlsheetvisible"

Then back to excel to see the results.

Repeat for any sheet you want to see.

==================
If you can't see the sheets in the VBE (and you can see the project), then the
sheets are no longer there.

It'll be time to restore your workbook from a backup.
 
D

Don

Are they just hidden? right click on the existing sheet name and see if you
can unhide the sheets. If no , then go into VB - developer function for 2007
and open the Microsoft Excel Objects folder under then name of the file. you
should have a Sheet 1 (name of sheet), Sheet2 (name of sheet) and if you see
the missing sheets but can not unhide , then it might be the Visible option
under Properties. You can hide a sheet where it is hard to see.

Not sure, but I think some space expecialy with versions of Excel before
2007 where it does not release space well even if you have removed data, so
not exactly sure if size makes a difference or at least for this case lol
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top