A
Alan
Hello friends
I created a spreadsheet in XL2002. When I opened it with XL2000 I got the following message..
AUTOMATIC ERROR
CATOSTROPHIC FAILUR
I opened the file back up on 2K2 and backsaved to 97-2000 version and got the message some formatting would be lost I opted to continue the save. When I open again on 2K, the file opens but some basic formatting is not there. Such as data validation, and basic conditional formatting. I can go back and reformat on 2K and it works. Is there anyway that the file can be opened in both versions and retain the formatting
Thanks
Alan
I created a spreadsheet in XL2002. When I opened it with XL2000 I got the following message..
AUTOMATIC ERROR
CATOSTROPHIC FAILUR
I opened the file back up on 2K2 and backsaved to 97-2000 version and got the message some formatting would be lost I opted to continue the save. When I open again on 2K, the file opens but some basic formatting is not there. Such as data validation, and basic conditional formatting. I can go back and reformat on 2K and it works. Is there anyway that the file can be opened in both versions and retain the formatting
Thanks
Alan