Color palette changes in Excel

[Regina]

I recently installed Excel 2002 at my office and I noticed
that after I open a workbook, every workbook I open after
that takes on the color palette of the first workbook.
Suddenly this starting happening at home. It is very
frustrating as I keep losing color palettes and my files
are sometimes unreadable. Has anyone experienced this? I
couldn't find anything on the Web or Microsoft.com about
it.

 

[Dave Peterson]

I use xl2002 at home and I don't think I've seen that behavior.

I take it you're not using one workbook for the basis of the next. That new
workbook will inherit the color palette the old one.

Can you experiment with a copy? Tools|Options|Color tab|Reset

Save it with the colors reset to normal and close it. Then open up the
workbooks with the palettes getting copied and then open your test copy. And
see if anything changes.

Even if I moved a sheet from one workbook to a different workbook, then the
colors changed to match the colors in the "to" workbook. (The "to" workbook
didn't change to match the "From" workbook.)

 

[Sandy V]

Bit of a long shot -
Do your problematic workbooks pre-date Excel97. The
default palettes changed. Even so normally this should not
be an issue, however I have experienced some problems
concerning old vs new default palettes.

Regards,
Sandy

 

[BLB]

I am having the same problem. I loaded Excel 2002 on Windows XP a fe
weeks ago. I did not change the default color pallet. However, all o
a sudden the pallet on some workbooks changed and when I open
workbooks (1 with the correct default pallet, and 1 that somehow go
modified), the 1st workbook takes on the pallet of the 2nd modifie
workbook. Very annoying to know that I highlited a cell in orange, bu
because I have a 2nd workbook open, that cell is now some brown color.

I have tried reinstalling MS Office. I can't copy the pallet from on
workbook to another because the problem is that the default pallet i
the one I want, but the modified pallet is the one that takes over.

This happened on several workbooks, but then others didn't get change
from the default... HELP