SSRS(sql server 2005) Need to change Excel sheets name
When i export into excel i have used page breaks so that my report exports into excel into different sheets but names are defaultly taken as sheet 1, sheet 2 and sheet 3 etc, i looked in online tried may things to change the sheet names but nothing worked could any one let me know the best way to change sheet names?