software

Hello,
I am exporting a report from crystal reports into Excel 2003 and I keep
getting an error message that Excel has quot;Renamed invalid sheet namequot;. It is
pulling up a Microsoft office Excel File Repair Log.

How can I make it stop doing this? is there a setting in excel that needs to
be changed?

How about changing CR so that it stops creating a worksheet with an invalid
name?
Angela wrote:
gt;
gt; Hello,
gt; I am exporting a report from crystal reports into Excel 2003 and I keep
gt; getting an error message that Excel has quot;Renamed invalid sheet namequot;. It is
gt; pulling up a Microsoft office Excel File Repair Log.
gt;
gt; How can I make it stop doing this? is there a setting in excel that needs to
gt; be changed?

--

Dave Peterson

CR?

quot;Dave Petersonquot; wrote:

gt; How about changing CR so that it stops creating a worksheet with an invalid
gt; name?
gt;
gt;
gt;
gt; Angela wrote:
gt; gt;
gt; gt; Hello,
gt; gt; I am exporting a report from crystal reports into Excel 2003 and I keep
gt; gt; getting an error message that Excel has quot;Renamed invalid sheet namequot;. It is
gt; gt; pulling up a Microsoft office Excel File Repair Log.
gt; gt;
gt; gt; How can I make it stop doing this? is there a setting in excel that needs to
gt; gt; be changed?
gt;
gt; --
gt;
gt; Dave Peterson
gt;

crystal reports

Angela wrote:
gt;
gt; CR?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; How about changing CR so that it stops creating a worksheet with an invalid
gt; gt; name?
gt; gt;
gt; gt;
gt; gt;
gt; gt; Angela wrote:
gt; gt; gt;
gt; gt; gt; Hello,
gt; gt; gt; I am exporting a report from crystal reports into Excel 2003 and I keep
gt; gt; gt; getting an error message that Excel has quot;Renamed invalid sheet namequot;. It is
gt; gt; gt; pulling up a Microsoft office Excel File Repair Log.
gt; gt; gt;
gt; gt; gt; How can I make it stop doing this? is there a setting in excel that needs to
gt; gt; gt; be changed?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Hi Dave,
I tried that, and it didn't work, but thank you so much for the suggestion.

I think Excel is trying to force in a name with a ~ in front of it when it
exports even though I changed the name. In any other version of excel it
exports just fine, and leaves the sheet name as quot;Sheetquot;. But in the Excel
2003 professional it trys to rename the sheet to the name of the report and I
think this is what is causing the error. I know the ~ is not a valid
character for a sheet, so I think Excel is trying to change that ~. I would
prefer if it did not add a sheet name at all and just left it as quot;Sheet1quot;
when being exported.

Any other suggestions?

quot;Dave Petersonquot; wrote:

gt; crystal reports
gt;
gt; Angela wrote:
gt; gt;
gt; gt; CR?
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; How about changing CR so that it stops creating a worksheet with an invalid
gt; gt; gt; name?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Angela wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Hello,
gt; gt; gt; gt; I am exporting a report from crystal reports into Excel 2003 and I keep
gt; gt; gt; gt; getting an error message that Excel has quot;Renamed invalid sheet namequot;. It is
gt; gt; gt; gt; pulling up a Microsoft office Excel File Repair Log.
gt; gt; gt; gt;
gt; gt; gt; gt; How can I make it stop doing this? is there a setting in excel that needs to
gt; gt; gt; gt; be changed?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I use xl2003 and I could name a sheet with the ~ character.

But if xl thinks that the sheet name is invalid, I don't think you can get into
xl's internals to change its behavior. (That's why I suggested changing the
Crystal Reports output--but I don't know if that's possible, either.)

Angela wrote:
gt;
gt; Hi Dave,
gt; I tried that, and it didn't work, but thank you so much for the suggestion.
gt;
gt; I think Excel is trying to force in a name with a ~ in front of it when it
gt; exports even though I changed the name. In any other version of excel it
gt; exports just fine, and leaves the sheet name as quot;Sheetquot;. But in the Excel
gt; 2003 professional it trys to rename the sheet to the name of the report and I
gt; think this is what is causing the error. I know the ~ is not a valid
gt; character for a sheet, so I think Excel is trying to change that ~. I would
gt; prefer if it did not add a sheet name at all and just left it as quot;Sheet1quot;
gt; when being exported.
gt;
gt; Any other suggestions?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; crystal reports
gt; gt;
gt; gt; Angela wrote:
gt; gt; gt;
gt; gt; gt; CR?
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; How about changing CR so that it stops creating a worksheet with an invalid
gt; gt; gt; gt; name?
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; Angela wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hello,
gt; gt; gt; gt; gt; I am exporting a report from crystal reports into Excel 2003 and I keep
gt; gt; gt; gt; gt; getting an error message that Excel has quot;Renamed invalid sheet namequot;. It is
gt; gt; gt; gt; gt; pulling up a Microsoft office Excel File Repair Log.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; How can I make it stop doing this? is there a setting in excel that needs to
gt; gt; gt; gt; gt; be changed?
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson


Angela wrote:
gt; Hello,
gt; I am exporting a report from crystal reports into Excel 2003 and I keep
gt; getting an error message that Excel has quot;Renamed invalid sheet namequot;. It is
gt; pulling up a Microsoft office Excel File Repair Log.
gt;
gt; How can I make it stop doing this? is there a setting in excel that needs to
gt; be changed?

If you do a search in CR Knowledgebase you will find source of bogus
Renaming is due to having nothing in CR Report Summary Info Title.

Fix by entering anything in Report Title and condition will cease for
all new spreadsheets.

Don't know how to fix already created spreadsheets - sorry.

LeeI too am having this same problem. Although, with my case, the title
is already placed in the CR Summary Info Title space. Are there any
other possibilities? Also, I am running Windows 2000, Excel 2002, CR
8.5.

Traviszod wrote:
gt; Angela wrote:
gt; gt; Hello,
gt; gt; I am exporting a report from crystal reports into Excel 2003 and I keep
gt; gt; getting an error message that Excel has quot;Renamed invalid sheet namequot;. It is
gt; gt; pulling up a Microsoft office Excel File Repair Log.
gt; gt;
gt; gt; How can I make it stop doing this? is there a setting in excel that needs to
gt; gt; be changed?
gt;
gt; If you do a search in CR Knowledgebase you will find source of bogus
gt; Renaming is due to having nothing in CR Report Summary Info Title.
gt;
gt; Fix by entering anything in Report Title and condition will cease for
gt; all new spreadsheets.
gt;
gt; Don't know how to fix already created spreadsheets - sorry.
gt;
gt; Lee