M
mcguigan
When opening a Cognos report in excel the word (grouped) appears next to the
report title. Sort option on excel is then not available.
report title. Sort option on excel is then not available.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duke Carey
Are multiple sheet tabs highlighted? If so, right click on one of the
highlighted tabs and choose Ungroup
highlighted tabs and choose Ungroup
G
Gord Dibben
And a note of caution here.......
While sheets have been "grouped", whatever you have done to one sheet will
have been done to all in the "group".
Best to have a close look at all sheets to see what havoc you may have
wreaked.
Gord Dibben Excel MVP
While sheets have been "grouped", whatever you have done to one sheet will
have been done to all in the "group".
Best to have a close look at all sheets to see what havoc you may have
wreaked.
Gord Dibben Excel MVP
F
Fredrik Wahlgren
Gord Dibben said:And a note of caution here.......
While sheets have been "grouped", whatever you have done to one sheet will
have been done to all in the "group".
Best to have a close look at all sheets to see what havoc you may have
wreaked.
I haven't heard about this feature. What does it mean the sheets have been
grouped?
/Fredrik
G
Gord Dibben
Fredrik
Select one sheet tab then hold CTRL key and select another sheet tab.
Make a change on first sheet, like color a cell or three.
Second sheet will have same change made.
You can group all sheets by right-click>Select All Sheets or by SHIFT + Click
to select contiguous sheets.
Or by the CTRL + Click to select non-contiguous sheets.
Whatever method is employed, you will see [Group] up in the title bar and the
grouped sheets tabs will be colored white.
Very handy feature for replicating across sheets, but can get a little hairy
if user forgets about it.
No warning other than the [Group] and the white tabs.
Gord
Select one sheet tab then hold CTRL key and select another sheet tab.
Make a change on first sheet, like color a cell or three.
Second sheet will have same change made.
You can group all sheets by right-click>Select All Sheets or by SHIFT + Click
to select contiguous sheets.
Or by the CTRL + Click to select non-contiguous sheets.
Whatever method is employed, you will see [Group] up in the title bar and the
grouped sheets tabs will be colored white.
Very handy feature for replicating across sheets, but can get a little hairy
if user forgets about it.
No warning other than the [Group] and the white tabs.
Gord