Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate cell row and column | Excel Discussion (Misc queries) | |||
How do i group worksheets inside a workbook into subgroups? | Excel Worksheet Functions | |||
Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |