Tabbed worksheets missing after conversion to 2007

[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?

 

[Ron de Bruin]

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

 

[Scooterman]

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?

 

[Ron de Bruin]

Hi Scooterman

Can you send me the workbook private
I like to see a workbook like this to see what the problem is.

Send it to my private mail on my webpage
http://www.rondebruin.nl/

 

[Delynn]

Do you have a solution to this yet? I am having this same problem.

 

[Ron de Bruin]

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

 

[Kelley]

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.

 

[njp]

Yikes! I have the same problem. Thankfully the workaround is to use Excel
2003. But I hope somebody can post a solution to this?

 

[njp]

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.

 

[Kelley]

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.