Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 216
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 216
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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.


  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,203
Default One workbook with 62 worksheets

That's pretty much what I was thinking - either a workspace with multiple
workbooks within it, or a 'master' workbook that is opening the other 61 when
it is opened.
But I've been wrong before - several times this week already, even.

"Gord Dibben" wrote:

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.



  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default One workbook with 62 worksheets

Thanks to Gord Dibben and JLatham for your comments. My apologies for my
delay in acknowledging.

As I noted in my original post, I've learned a lot from this site. However,
the term "workspace" was new to me - or at least my memory. I searched for
"workspace" on this site and found a few posts. Unfortunately, I'm somewhat
pressed for time - will be away from work for 10 days - and don't have time
right now to do much studying/learning.

However, one thing I did see was an indication that saved workspace would
end with ".xlw" as opposed to the ".xls" on my file. Is this correct?

When I do open the ".xls" workbook, the Excel tab/button in my taskbar reads
"62 Microsoft Office Excel" and when I hover it displays all 62. Each of the
62 have all 62 worksheets and the displayed filenames are in the format of
"myfile.xls:1", "myfile.xls:2", ... "myfile.xls:62". Is the colon + number
at the end an indicator that I'm working with workspace versus workbook? If
it has been saved as workspace, how do I save it as simply a workbook? I've
tried to save it as both ".xls" and ".xlsx" but it always opens with 62
entries on my taskbar with the colon + numbers.

Thanks for your time and attention. I'll be checking back for any
additional information, but it will be a couple of weeks before I can
acknowledge.



"JLatham" wrote:

That's pretty much what I was thinking - either a workspace with multiple
workbooks within it, or a 'master' workbook that is opening the other 61 when
it is opened.
But I've been wrong before - several times this week already, even.

"Gord Dibben" wrote:

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.



  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default One workbook with 62 worksheets

It sounds like you have 62 windows open on the same workbook. Close each
one in turn (not with the red X for the whole application in the extreme top
right-hand corner but with the blue X for the window immediately below it)
until you have only one window left open. Then save the workbook and
reopen. It should then have only one window open.
--
David Biddulph

"Colts41" wrote in message
...
Thanks to Gord Dibben and JLatham for your comments. My apologies for my
delay in acknowledging.

As I noted in my original post, I've learned a lot from this site.
However,
the term "workspace" was new to me - or at least my memory. I searched
for
"workspace" on this site and found a few posts. Unfortunately, I'm
somewhat
pressed for time - will be away from work for 10 days - and don't have
time
right now to do much studying/learning.

However, one thing I did see was an indication that saved workspace would
end with ".xlw" as opposed to the ".xls" on my file. Is this correct?

When I do open the ".xls" workbook, the Excel tab/button in my taskbar
reads
"62 Microsoft Office Excel" and when I hover it displays all 62. Each of
the
62 have all 62 worksheets and the displayed filenames are in the format of
"myfile.xls:1", "myfile.xls:2", ... "myfile.xls:62". Is the colon +
number
at the end an indicator that I'm working with workspace versus workbook?
If
it has been saved as workspace, how do I save it as simply a workbook?
I've
tried to save it as both ".xls" and ".xlsx" but it always opens with 62
entries on my taskbar with the colon + numbers.

Thanks for your time and attention. I'll be checking back for any
additional information, but it will be a couple of weeks before I can
acknowledge.



"JLatham" wrote:

That's pretty much what I was thinking - either a workspace with multiple
workbooks within it, or a 'master' workbook that is opening the other 61
when
it is opened.
But I've been wrong before - several times this week already, even.

"Gord Dibben" wrote:

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.




  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default One workbook with 62 worksheets

*.xlw is a workspace file containing one or more workbooks.

But..........your *.xls:1 and *.xls:2 are windows of the same workbook.

See other responses for cure for that.


Gord

On Thu, 11 Jun 2009 09:18:01 -0700, Colts41
wrote:

Thanks to Gord Dibben and JLatham for your comments. My apologies for my
delay in acknowledging.

As I noted in my original post, I've learned a lot from this site. However,
the term "workspace" was new to me - or at least my memory. I searched for
"workspace" on this site and found a few posts. Unfortunately, I'm somewhat
pressed for time - will be away from work for 10 days - and don't have time
right now to do much studying/learning.

However, one thing I did see was an indication that saved workspace would
end with ".xlw" as opposed to the ".xls" on my file. Is this correct?

When I do open the ".xls" workbook, the Excel tab/button in my taskbar reads
"62 Microsoft Office Excel" and when I hover it displays all 62. Each of the
62 have all 62 worksheets and the displayed filenames are in the format of
"myfile.xls:1", "myfile.xls:2", ... "myfile.xls:62". Is the colon + number
at the end an indicator that I'm working with workspace versus workbook? If
it has been saved as workspace, how do I save it as simply a workbook? I've
tried to save it as both ".xls" and ".xlsx" but it always opens with 62
entries on my taskbar with the colon + numbers.

Thanks for your time and attention. I'll be checking back for any
additional information, but it will be a couple of weeks before I can
acknowledge.



"JLatham" wrote:

That's pretty much what I was thinking - either a workspace with multiple
workbooks within it, or a 'master' workbook that is opening the other 61 when
it is opened.
But I've been wrong before - several times this week already, even.

"Gord Dibben" wrote:

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.





  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,203
Default One workbook with 62 worksheets

I believe that David and Gord have it pretty well covered: you've got 62
windows for the same workbook. Your last post gave us the clues we needed to
pin it down.

"Colts41" wrote:

Thanks to Gord Dibben and JLatham for your comments. My apologies for my
delay in acknowledging.

As I noted in my original post, I've learned a lot from this site. However,
the term "workspace" was new to me - or at least my memory. I searched for
"workspace" on this site and found a few posts. Unfortunately, I'm somewhat
pressed for time - will be away from work for 10 days - and don't have time
right now to do much studying/learning.

However, one thing I did see was an indication that saved workspace would
end with ".xlw" as opposed to the ".xls" on my file. Is this correct?

When I do open the ".xls" workbook, the Excel tab/button in my taskbar reads
"62 Microsoft Office Excel" and when I hover it displays all 62. Each of the
62 have all 62 worksheets and the displayed filenames are in the format of
"myfile.xls:1", "myfile.xls:2", ... "myfile.xls:62". Is the colon + number
at the end an indicator that I'm working with workspace versus workbook? If
it has been saved as workspace, how do I save it as simply a workbook? I've
tried to save it as both ".xls" and ".xlsx" but it always opens with 62
entries on my taskbar with the colon + numbers.

Thanks for your time and attention. I'll be checking back for any
additional information, but it will be a couple of weeks before I can
acknowledge.



"JLatham" wrote:

That's pretty much what I was thinking - either a workspace with multiple
workbooks within it, or a 'master' workbook that is opening the other 61 when
it is opened.
But I've been wrong before - several times this week already, even.

"Gord Dibben" wrote:

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.


  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default One workbook with 62 worksheets

Thanks David! That solved my problem.

And thanks again to Nadine, Gord and JLatham.

"David Biddulph" wrote:

It sounds like you have 62 windows open on the same workbook. Close each
one in turn (not with the red X for the whole application in the extreme top
right-hand corner but with the blue X for the window immediately below it)
until you have only one window left open. Then save the workbook and
reopen. It should then have only one window open.
--
David Biddulph

"Colts41" wrote in message
...
Thanks to Gord Dibben and JLatham for your comments. My apologies for my
delay in acknowledging.

As I noted in my original post, I've learned a lot from this site.
However,
the term "workspace" was new to me - or at least my memory. I searched
for
"workspace" on this site and found a few posts. Unfortunately, I'm
somewhat
pressed for time - will be away from work for 10 days - and don't have
time
right now to do much studying/learning.

However, one thing I did see was an indication that saved workspace would
end with ".xlw" as opposed to the ".xls" on my file. Is this correct?

When I do open the ".xls" workbook, the Excel tab/button in my taskbar
reads
"62 Microsoft Office Excel" and when I hover it displays all 62. Each of
the
62 have all 62 worksheets and the displayed filenames are in the format of
"myfile.xls:1", "myfile.xls:2", ... "myfile.xls:62". Is the colon +
number
at the end an indicator that I'm working with workspace versus workbook?
If
it has been saved as workspace, how do I save it as simply a workbook?
I've
tried to save it as both ".xls" and ".xlsx" but it always opens with 62
entries on my taskbar with the colon + numbers.

Thanks for your time and attention. I'll be checking back for any
additional information, but it will be a couple of weeks before I can
acknowledge.



"JLatham" wrote:

That's pretty much what I was thinking - either a workspace with multiple
workbooks within it, or a 'master' workbook that is opening the other 61
when
it is opened.
But I've been wrong before - several times this week already, even.

"Gord Dibben" wrote:

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many worksheets can you have in one workbook? KG Excel Discussion (Misc queries) 9 April 14th 10 04:47 PM
Combine worksheets in multiple workbook in one workbook with a macro Sam Commar Excel Discussion (Misc queries) 2 April 2nd 09 01:09 PM
Create New Workbook from Worksheets in One Workbook Dave Excel Discussion (Misc queries) 4 June 17th 07 10:27 PM
How do I build a workbook from the worksheets another workbook? Rico Excel Discussion (Misc queries) 4 August 19th 05 02:04 PM
Worksheets in a workbook? Bob .-.-. New Users to Excel 4 June 23rd 05 10:30 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"