I am using crystal reports to export data to an excel spreadsheet. in office
2000 the spread sheets open fine, but in office 2003 or office xp i get an
error saying that office was able to open the file but had to rename an
invalid worksheet. The sheet is originally names Sheet1. How can i fix this
issue?

This is an issue because I am currently writing a script that will take
multiple excel spreadsheets and import them into a sql server database. when
i go to open the excel spread sheets via the script i get an error saying
that an error occured, but the engine running the script does not know what
error. I think this is the error because if i rename the sheets and try the
script again, it works.

thanks for any and all help!

Ben