Dynamic naming of Excel work sheet Sheet tab

[kalyan_sekhar1]

Hi All,

I am running a report in the Excel in which the different lists placed in the report will be stored in different work sheet tabs in the same excel file

The work sheet tab name is always the page name which is defined. LEts say for e.g if Page Name is "Scorecard" then the work sheet tab names as "Scorecard-1", "Scorecard-2"...

Rather then having a staic name, i want to have a dynamic name lets say if there is a Query item "Scorecard Name", can i assign this? so that i can populate the work sheet names dynamically

Thanks

[gops210]

Hi Kalyan,
                Im facing the similar requirement,could u please share ur suggestions if u got the solution.

Thanks in advance

[AnthonyJ]

Any luck with this ? Are you able to achieve dynamic sheet names in Excel simply by using an item's LOV ?