Renamed invalid sheet name

  • Thread starter Thread starter J
  • Start date Start date
J

J

I have an MS Access Database that after running a query I
send to Excel. When I do I get an error message that
reads as follows:
"Errors were detected in "filename.xls", but Microsoft
Excel was able to open the file by making the repairs
listed below. Save the file to make these repairs
permanent"
"Renamed invalid sheet name"

The query in Access has a / in the name of report and I
believe that might be the problem with Excel xp but I
need a work around.

It works fine in Excel 2000 and Excel 2003, just not XP.

Any solution?
 
J

I'm not sure how it works in the other versions. Does it change the / to
something else? All file and folder characters are illegal for sheet names
and have always been. *,/,\.?, etc

Can you not change the report name. If this is a date I always use a
dash -. Excel will allow this but still recognise it as a date.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top