I'm writing a spreadsheet in Excel 2007, in compatability mode 2003, however it still lets me use formats/colours that are not compatable and just warns me when saving or using the Prepare/Compatability Check feature.
If i save the document and re-open it i still see in 2007 the 2007 [incompatable] colours.
How can i make it so that in 2007 i can ONLY select colours/formats that are compatabile in the first place.
I do not seem to be able to see, in 2007, how the sheet will look in 2003.
Can this be done?
I simply want to be able to only select compatable formats in the first place.
Thanks for reading.
Bookmarks