Cannot Group Seven Worksheets, only Six

I try to group seven worksheets together, so the changes I make in one apply
to all others, but then if I select one of those seven after I have done
"select all worksheets" or shift-<worksheet> for all, then they no longer
show up as being grouped. However, if I do the same for six of the seven
worksheets, then I can click back and forth between the six and they still
show as being grouped (all white tabs).

Is there a limitation in Excel for this? I have Excel 2002 SP3


--
Thanks, J.

Since each change you make will be applied to all of the grouped sheets, do you
really have to go to the other sheet?

What happens if you try selecting one of the grouped sheets by using rightclick
(then click somewhere to dismiss that popup dialog)?

ps.

In xl2003, if I group all the sheets, then selecting one of the grouped sheets
ungroups them. But if I select less than all (7 of 8??), I could just click on
any of the grouped worksheets I want.

So you could add an extra sheet, don't include that in your group, do all the
work, then delete that added worksheet.


Josma wrote:
>
> I try to group seven worksheets together, so the changes I make in one apply
> to all others, but then if I select one of those seven after I have done
> "select all worksheets" or shift-<worksheet> for all, then they no longer
> show up as being grouped. However, if I do the same for six of the seven
> worksheets, then I can click back and forth between the six and they still
> show as being grouped (all white tabs).
>
> Is there a limitation in Excel for this? I have Excel 2002 SP3
>
> --
> Thanks, J.

--

Dave Peterson

Yes, the other sheets have filters for other users that will be viewing the
data. Makes it easier for them.

If I right click on a group sheet and click on another one to dismiss, same
thing happens. No more grouping.

If I create the extra sheet then it works. But this seems like a bug to me
based on the documentation.

--
Thanks, J.


"Dave Peterson" wrote:

> Since each change you make will be applied to all of the grouped sheets, do you
> really have to go to the other sheet?
>
> What happens if you try selecting one of the grouped sheets by using rightclick
> (then click somewhere to dismiss that popup dialog)?
>
> ps.
>
> In xl2003, if I group all the sheets, then selecting one of the grouped sheets
> ungroups them. But if I select less than all (7 of 8??), I could just click on
> any of the grouped worksheets I want.
>
> So you could add an extra sheet, don't include that in your group, do all the
> work, then delete that added worksheet.
>
>
> Josma wrote:
> >
> > I try to group seven worksheets together, so the changes I make in one apply
> > to all others, but then if I select one of those seven after I have done
> > "select all worksheets" or shift-<worksheet> for all, then they no longer
> > show up as being grouped. However, if I do the same for six of the seven
> > worksheets, then I can click back and forth between the six and they still
> > show as being grouped (all white tabs).
> >
> > Is there a limitation in Excel for this? I have Excel 2002 SP3
> >
> > --
> > Thanks, J.
>
> --
>
> Dave Peterson
>

Don't click on another sheet to dismiss that popup. Click somewhere on that
same worksheet.

Josma wrote:
>
> Yes, the other sheets have filters for other users that will be viewing the
> data. Makes it easier for them.
>
> If I right click on a group sheet and click on another one to dismiss, same
> thing happens. No more grouping.
>
> If I create the extra sheet then it works. But this seems like a bug to me
> based on the documentation.
>
> --
> Thanks, J.
>
> "Dave Peterson" wrote:
>
> > Since each change you make will be applied to all of the grouped sheets, do you
> > really have to go to the other sheet?
> >
> > What happens if you try selecting one of the grouped sheets by using rightclick
> > (then click somewhere to dismiss that popup dialog)?
> >
> > ps.
> >
> > In xl2003, if I group all the sheets, then selecting one of the grouped sheets
> > ungroups them. But if I select less than all (7 of 8??), I could just click on
> > any of the grouped worksheets I want.
> >
> > So you could add an extra sheet, don't include that in your group, do all the
> > work, then delete that added worksheet.
> >
> >
> > Josma wrote:
> > >
> > > I try to group seven worksheets together, so the changes I make in one apply
> > > to all others, but then if I select one of those seven after I have done
> > > "select all worksheets" or shift-<worksheet> for all, then they no longer
> > > show up as being grouped. However, if I do the same for six of the seven
> > > worksheets, then I can click back and forth between the six and they still
> > > show as being grouped (all white tabs).
> > >
> > > Is there a limitation in Excel for this? I have Excel 2002 SP3
> > >
> > > --
> > > Thanks, J.
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson