I have designed a stored procedure, from which a Crystal Report is designed. From Crystal Management, the report is exported to Excel and stored in a folder so it can be imported into a new system. All this works fine, except the App used for importing cannot find the worksheet if it has the name Sheet1 — which is the default.
How do I get Crystal Reports to change the name of the sheet to something else without having to go in and update all this Excel file by hand?