rename invalid sheet name from access 97 report to Excel 2002

  • Thread starter Thread starter dls99
  • Start date Start date
D

dls99

When I export a file from Access 97, my only choice is to
export to Excel 97. I then open that file, with excel
2002, and I get an error message the the sheet had an
invalid name and had to be renamed, but there is no
apparent difference in the the name "Sheet1" in excel 97
or "sheet1" in Excel 2002.

(I can find NO conversion sw, or find any way to "add to"
my file types list. I am forced to use Access 97 with the
office 2002 suite for now)

Any Ideas on what is causing this?
DLS 99
 
Can you open the file in xl97 to see what the sheet name is/was?

Or do you know what the sheet name would have been.

On the other hand, if xl2002 didn't like the name and changed it to something it
found ok, why bother worrying?

Just curious.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Renamed Invalid Sheet Name 1
Renamed invalid sheet name 7
EXCEL - IF(IFERROR(VLOOKUP question 0
Excel 97 autosum changed by Excel 2002 1
Excel 2002 can't open Excel 97 properly ? 1
Backwards Compatibility with Excel 2002 2
editing an excel 97 file within excel 2003 and saving back as exce 3
Excel 97 and Excel 2002 2

Back
Top