Tabbed worksheets missing after conversion to 2007
 

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?

Tabbed worksheets missing after conversion to 2007
 

You are not the only one with this problem

Use this to see them

Office ButtonExcel options

Advanced

See Diplay options for this workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scooterman" wrote in message ...
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?

Tabbed worksheets missing after conversion to 2007
 

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" wrote:

You are not the only one with this problem

Use this to see them

Office ButtonExcel options

Advanced

See Diplay options for this workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scooterman" wrote in message ...
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?

Tabbed worksheets missing after conversion to 2007
 

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/


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scooterman" wrote in message ...
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" wrote:

You are not the only one with this problem

Use this to see them

Office ButtonExcel options

Advanced

See Diplay options for this workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scooterman" wrote in message ...
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?

Tabbed worksheets missing after conversion to 2007
 

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

"Ron de Bruin" wrote:

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/


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scooterman" wrote in message ...
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" wrote:

You are not the only one with this problem

Use this to see them

Office ButtonExcel options

Advanced

See Diplay options for this workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scooterman" wrote in message ...
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?

Tabbed worksheets missing after conversion to 2007
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Delynn" wrote in message ...
Do you have a solution to this yet? I am having this same problem.

"Ron de Bruin" wrote:

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/


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scooterman" wrote in message ...
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" wrote:

You are not the only one with this problem

Use this to see them

Office ButtonExcel options

Advanced

See Diplay options for this workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scooterman" wrote in message
...
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?

Tabbed worksheets missing after conversion to 2007
 

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.

"Scooterman" wrote:

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?

Tabbed worksheets missing after conversion to 2007
 

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

"Scooterman" wrote:

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?

Tabbed worksheets missing after conversion to 2007
 

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.

"njp" wrote:

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

"Scooterman" wrote:

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?

Tabbed worksheets missing after conversion to 2007
 

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.

"njp" wrote:

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.

"njp" wrote:

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

"Scooterman" wrote:

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?