Sir Babydum GBE
10-05-2005, 01:47 AM
Hi
I created a document using Excel 97 which some users of Excel 2000 couldn't open (An application error would shut excel down when they tried to open it).
Thinking it might be a compatibility issue with VBA, a stripped away all code from the workbook - but to no avail. I removed all objects, conditional formatting, names, changed all formulae to values and saved. Still nothing. The only way I could get round it was to copy and paste the info into a brand new workbook - which bacame identical to the original. That worked.
I'd like to say the original was corrupt - but all the while users of Excel 97 were able to open it without any issues - even when it was full of code and formatting.
Any ideas why this might have happened - and what to do if I encounter it again?
Thanks
I created a document using Excel 97 which some users of Excel 2000 couldn't open (An application error would shut excel down when they tried to open it).
Thinking it might be a compatibility issue with VBA, a stripped away all code from the workbook - but to no avail. I removed all objects, conditional formatting, names, changed all formulae to values and saved. Still nothing. The only way I could get round it was to copy and paste the info into a brand new workbook - which bacame identical to the original. That worked.
I'd like to say the original was corrupt - but all the while users of Excel 97 were able to open it without any issues - even when it was full of code and formatting.
Any ideas why this might have happened - and what to do if I encounter it again?
Thanks