Table header is not repeating on every page in print preview in excel file exported through ssrs

Hi,

when I export a excel file throuh ssrs 2008 then i got in print preview of excel table header is not repeating

on each page. I have done the advance mode setting like :

fixedData-True,

KeepWithGroup-After

repeatOnNewPage-True,

But still not  getting table header on each page, but it works  in pdf format.

Please sussgest me any idea. I also try to put text box in page header and try to get what i want to get

through table header but get another issue which is not fit for my report.

Please suggest me, what i have to do for getting table header on each page.

Thanks in Advance

Saurabh Kasyap

Exporting to Excel defaults so that it is optimized for viewing on screen.  

Use the InitialPage property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the PageName property to provide different names for each worksheet. Each new report page, defined by a page break, is exported to a different worksheet named by the value of the PageName property. If PageName is blank, but the report has an initial page name, then all worksheets in the Excel workbook use the same name, the initial page name.

For more information:

Pagination in Reporting Services

Exporting to Excel (SSRS)