Tabbed worksheets missing after conversion to 2007

  • Thread starter Thread starter Scooterman
  • Start date Start date
S

Scooterman

I have a workbook that has multiple worksheets tabbed by month at the bottom
of the screen in Excel 2000 and 2003. When I open the spreadsheet in 2007
only the first group is visible. I cannot find the other sheets, nor does
anything show up under "unhide".

When I reopen it with the older versions, the missing sheets are still there.

How do I see them in 2007?
 
You are not the only one with this problem

Use this to see them

Office Button>Excel options

Advanced

See Diplay options for this workbook
 
Thanks Ron.

This would seem to be exactly the problem. I found the "advanced" options
you mention, only to find that the Display Tabs for the Workbook was already
checked. I tried unchecking it - no tabs. I tried rechecking it - no tabs.

In the Worksheet display options however it lists all the worksheets I want
to see - so it knows they are there. Any other suggestions?
 
Hi Delynn
Do you have a solution to this yet? I am having this same problem.

No, but i like to see your workbook so I can see it and see if I can find a solution

Scooterman have not send me his workbook
 
Have you gotten this resolved? My company is in the process of converting
from 2000 to 2007 and I'm encountering this exact same problem.
 
Yikes! I have the same problem. Thankfully the workaround is to use Excel
2003. But I hope somebody can post a solution to this?
 
I don't know if this will help others, but I resolved my problem. It was
actually quite simple.
Review tab > Protect Workbook > uncheck Protect Structure and Windows

What was causing my problem was that when I saw "Protect" Workbook, I
assumed it was UNprotected. It seems elsewhere the protect/unprotect terms
toggle to display the opposite of what they are set at.
 
Yep, that's another thing to check. Besides making sure all the correct
options are checked in the ADVANCED settings, make sure the
worksheet/workbook is unprotected! The protection seems to be kind of
"backwards" compared to the older versions. But you're absolutely right!
Thanks.
 

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

Back
Top