The new Excel 2007 shore is purty, but none of us understand the new Excel
2007 color system (well, at least I don't). One particular lack of
understanding involves color compatibility. All of my work is either 2000 to
2003 or 2007, nothing important crosses the threshold, so I haven't had to
learn about it yet.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"JCooper" wrote in message
...
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.