View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JCooper JCooper is offline
external usenet poster
 
Posts: 4
Default Excel 2007 Color Backward-Compatibility Issue

QUESTION: I can open in Excel 2007 spreadsheets created in Excel 2003,
showing the original colors for fonts, backgrounds and borders. However, I
cannot continue using those colors as I expand the spreadsheet with Excel
2007 because the color palette is completely changed. I am forced to mix in
new colors with the old. BTW- we use a GPO to employ the office comp pack so
office 2007 users save to 97-2003.

1) Did Microsoft abandon backward compatibility regarding colors, or am I
missing something?

2) Is there a work-around or an add-on that will do the job?

3) If there is a work-around or add-on can it provide the old classic set
of 40 colors as the default WHICH WILL OPEN FOR EVERY OLD AND NEW SPREADSHEET
in Excel 2007 (and not require redoing for each old and new spreadsheet)?

4) what do we do with Old documents created in excel 2003 when our company
moves to Office 2007- will MS have a fix for this so we can open the docs in
either version and see the same thing in both without worring the colors
(that indicate data) may be miscinturpreted by a client becuase of this.

Sorry for the vent---this is frustrating as I see no solution for this.