I am combining multiple identical reports in a report book and then saving the rendered report in an Excel 97-2003 Worksheet file. I'm getting the following error when Excel tries to open the generated report:
Trusting in myself, I click yes and Excel repairs the file claiming it renamed an invalid worksheet name for each report (I'm naming each report with a unique name using report.Name). The excel file then has one perfectly rendered worksheet with the name I gave it and an identical one beside it with a name like 'Recovered_Sheet1'.
What am I doing that would cause this. Is there a special way to set each name in a report book that's different from naming each report?
BTW, I'm not using the viewer for any of this, just rendering the file directly.