My report written in Crystal 11.5 and exported to Excel (standard export, not Data Only) causes an error 1004 'unable to read file' in Excel 2003 when another spreadsheet is opened with links to the exported spreadsheet.
I have isolated the problem to be in the exported spreadsheet. If I open the exported spreadsheet and save it without changing anything - it works.
I have tried cleaning up the Crystal report so that all fields are aligned to margins both vertical and horizontal tabs. Is there any suggestions how to avoid Crystal generating a problematic spreadsheet. (and exporting with Data Only is worse)