How to change the Excel sheet TAB Name.

[EArumugam]

Hi Gurus,

I have to change the excel sheet TAB name when exporting to excel 2007.

by default i am getting Page-1, Page-2.

I created a page set for my report. Each country displaying in seperate TAb in the excel. I want to display the corresponding coutry name in each TAB.

how can we achieve this.

Please.

Version-cognos 8.4

Thnx,
eas

[TheDarkKnight]

Hi Easwar,
Once had this sort of requirement.but didnot got any soln :!. to associate the dataitem with the page names..

May be cognos 10 might help.

Cheers
TDK

[Dino1]

This can not be done within Report Studio. I use an excel macro to rename the tabs after the report has been run. I'm sure that is not what you wanted to hear but it is the only solution I have found.

[barrysaab]

The other workaround i think is to create multiple pages with the page names you want to display in excel ,by this way when the report is run it shows the name you have actually given. Thanks

[PRIT AMRIT]

Hi Dino,

This can not be done within Report Studio. I use an excel macro to rename the tabs after the report has been run. I'm sure that is not what you wanted to hear but it is the only solution I have found.

I very much agree with Dino.

Can you pls pass on the excel macro?

Thanks
Prit