Excel tab name when exporting from CR11

[suechamps]

Hello,

I have just begun to use Crystal 11. Previously I was using 8.5. When exporting to Excel I am using Microsoft Excel 97-2000 - Data only(XLS). When report is opened in Excel, the tab name of the report is "Sheet 1". In 8.5 the tab name of the exported report would be the file name of the Crystal report. This is affecting previously set up Excel formulas. Is there a way to pre-determine what the tab name of the Excel report will be when exporting from Cyrstal 11?

Thank you in advance for your help,
Sue

 

[IdoMillet]

No such option in Crystal Designer. There is at least one 3rd-party Report Manager among those listed at

http://www.kenhamady.com/bookmarks.html

that allows you to control the tab name of the export. It also allows you to insert the export as a new tab inside an existing workbook (or replace/append the existing tab).

hth,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com