Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One workbook with 62 worksheets
I have an old Excel workbook that might have started out as a Lotus 123
workbook. The original creator of the workbook is long gone and forgotten. My problem is that whenever the workbook is opened the taskbar at the bottom creates a separate entry for each of the 62 worksheets. When I have other workbooks open, it's a pain navigating through all the entries to find the other workbooks. I am currently using Office 2007, but this problem occurred in all earlier versions as well. Do I have an Excel problem or a Windows (taskbar) problem? Is there a way to stop this and just display the workbook and not all the worksheets? Thanks to all those who contribute answers/solutions to this site. I've learned a lot in my visits here. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One workbook with 62 worksheets
What operating system are you using.
"Colts41" wrote: I have an old Excel workbook that might have started out as a Lotus 123 workbook. The original creator of the workbook is long gone and forgotten. My problem is that whenever the workbook is opened the taskbar at the bottom creates a separate entry for each of the 62 worksheets. When I have other workbooks open, it's a pain navigating through all the entries to find the other workbooks. I am currently using Office 2007, but this problem occurred in all earlier versions as well. Do I have an Excel problem or a Windows (taskbar) problem? Is there a way to stop this and just display the workbook and not all the worksheets? Thanks to all those who contribute answers/solutions to this site. I've learned a lot in my visits here. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One workbook with 62 worksheets
Thanks for responding Nadine.
I'm using Windows XP. "Nadine" wrote: What operating system are you using. "Colts41" wrote: I have an old Excel workbook that might have started out as a Lotus 123 workbook. The original creator of the workbook is long gone and forgotten. My problem is that whenever the workbook is opened the taskbar at the bottom creates a separate entry for each of the 62 worksheets. When I have other workbooks open, it's a pain navigating through all the entries to find the other workbooks. I am currently using Office 2007, but this problem occurred in all earlier versions as well. Do I have an Excel problem or a Windows (taskbar) problem? Is there a way to stop this and just display the workbook and not all the worksheets? Thanks to all those who contribute answers/solutions to this site. I've learned a lot in my visits here. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One workbook with 62 worksheets
Have you tried converting the workbook into Excel 2007 (save as exce 2007)
Could also try checking properties of windows task bar - right click on start - left click on properties - Task Bar - select Group similar taskbar buttons Could also try from excel -Office Orb - Excel Options - Advances - Display - Show all windows in task bar (but that will limit only one workbook showing on the windows taskbar), won't show when have multiple workbooks open. Would have to go to the View Tab - select switch windows - to move between the workbooks. But I'm new to using Excel 2007 there maybe another setting. That could be causing this. May want to wait for an expert opinion. "Colts41" wrote: Thanks for responding Nadine. I'm using Windows XP. "Nadine" wrote: What operating system are you using. "Colts41" wrote: I have an old Excel workbook that might have started out as a Lotus 123 workbook. The original creator of the workbook is long gone and forgotten. My problem is that whenever the workbook is opened the taskbar at the bottom creates a separate entry for each of the 62 worksheets. When I have other workbooks open, it's a pain navigating through all the entries to find the other workbooks. I am currently using Office 2007, but this problem occurred in all earlier versions as well. Do I have an Excel problem or a Windows (taskbar) problem? Is there a way to stop this and just display the workbook and not all the worksheets? Thanks to all those who contribute answers/solutions to this site. I've learned a lot in my visits here. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One workbook with 62 worksheets
Tried your suggestions - but no luck. Fortunately this file is only in use
for 2-3 weeks of each year to produce the 62 pages of an annual report. Thanks for the effort. "Nadine" wrote: Have you tried converting the workbook into Excel 2007 (save as exce 2007) Could also try checking properties of windows task bar - right click on start - left click on properties - Task Bar - select Group similar taskbar buttons Could also try from excel -Office Orb - Excel Options - Advances - Display - Show all windows in task bar (but that will limit only one workbook showing on the windows taskbar), won't show when have multiple workbooks open. Would have to go to the View Tab - select switch windows - to move between the workbooks. But I'm new to using Excel 2007 there maybe another setting. That could be causing this. May want to wait for an expert opinion. "Colts41" wrote: Thanks for responding Nadine. I'm using Windows XP. "Nadine" wrote: What operating system are you using. "Colts41" wrote: I have an old Excel workbook that might have started out as a Lotus 123 workbook. The original creator of the workbook is long gone and forgotten. My problem is that whenever the workbook is opened the taskbar at the bottom creates a separate entry for each of the 62 worksheets. When I have other workbooks open, it's a pain navigating through all the entries to find the other workbooks. I am currently using Office 2007, but this problem occurred in all earlier versions as well. Do I have an Excel problem or a Windows (taskbar) problem? Is there a way to stop this and just display the workbook and not all the worksheets? Thanks to all those who contribute answers/solutions to this site. I've learned a lot in my visits here. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One workbook with 62 worksheets
FWIW..........I have never seen worksheet tabs show up in the TaskBar as
individual workbooks. Are you sure it is a single workbook with 62 sheets or a workspace with 62 books opening? Having not seen this before I am at a loss for further suggestions. Gord Dibben MS Excel MVP On Wed, 10 Jun 2009 14:40:01 -0700, Colts41 wrote: Tried your suggestions - but no luck. Fortunately this file is only in use for 2-3 weeks of each year to produce the 62 pages of an annual report. Thanks for the effort. "Nadine" wrote: Have you tried converting the workbook into Excel 2007 (save as exce 2007) Could also try checking properties of windows task bar - right click on start - left click on properties - Task Bar - select Group similar taskbar buttons Could also try from excel -Office Orb - Excel Options - Advances - Display - Show all windows in task bar (but that will limit only one workbook showing on the windows taskbar), won't show when have multiple workbooks open. Would have to go to the View Tab - select switch windows - to move between the workbooks. But I'm new to using Excel 2007 there maybe another setting. That could be causing this. May want to wait for an expert opinion. "Colts41" wrote: Thanks for responding Nadine. I'm using Windows XP. "Nadine" wrote: What operating system are you using. "Colts41" wrote: I have an old Excel workbook that might have started out as a Lotus 123 workbook. The original creator of the workbook is long gone and forgotten. My problem is that whenever the workbook is opened the taskbar at the bottom creates a separate entry for each of the 62 worksheets. When I have other workbooks open, it's a pain navigating through all the entries to find the other workbooks. I am currently using Office 2007, but this problem occurred in all earlier versions as well. Do I have an Excel problem or a Windows (taskbar) problem? Is there a way to stop this and just display the workbook and not all the worksheets? Thanks to all those who contribute answers/solutions to this site. I've learned a lot in my visits here. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many worksheets can you have in one workbook? | Excel Discussion (Misc queries) | |||
Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
Create New Workbook from Worksheets in One Workbook | Excel Discussion (Misc queries) | |||
How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) | |||
Worksheets in a workbook? | New Users to Excel |