Unable to open 2003

Topic

New Reply

Hello.

I have an Excel 2003 workbook which has links to other workbooks, many sheets and vba modules.
If I attempt to open it in 2007 I receieve ‘File error: data may have been lost’ and it doesn’t open.
If I ‘Open and Repair’ it, it can open but without any formatting, links or modules. Help please:-)
Andy.

Reply | Quote

Replies

Andy,

it sounds as if your database falls foul of compatibility issues. We get so used to new versions of Office opening earlier versions seamlessly, that it is easy to forget it is not always the case.

Have a look at Compatibilty to see Microsoft’s own list of issues.

If this is the cause of the problem, I don’t envy you the task of stripping the modules or worksheets out one at a time, but hey, somebody’s gotta do it!

Regards,

Jules

Reply | Quote