| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add-Ins tab missing in Excel 2007 | Setting up and Configuration of Excel | |||
| Traditional-Simplified Chinese conversion in Excel 2007(Eng versio | Excel Discussion (Misc queries) | |||
| where is confirm conversion at open in Excel 2007? ('03 tools opt | Excel Discussion (Misc queries) | |||
| Excel 2007 conversion - this file contains labels in formulas | Excel Discussion (Misc queries) | |||
| Excel 2007 - Problems using print preview and PDF/XPS conversion without having a printer defined | Excel Discussion (Misc queries) | |||
Hybrid Mode
