Excel Bug

[SpartanXY]

Hi

I've an excel file with number of charts. Anytime I open another excel
file in the same workbook, I find the colors on my original sheet
change. Not just that, the color pallete also changes from the standard
colors to something else.

It's really annoying - has anyone else experienced this? The new file
has no macros etc - so it should not be messing up anything.


Pls help!

thanks
sp

 

[Chip Pearson]

Go to the Tools menu, choose Options, then Colors. There, click
the Reset button.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[SpartanXY]

Thanks Chip

Ok that takes care of the color pallete - what do I do about the other
objects? eg- my worksheet which was initially white, is now blue. The
bar charts - initially dark blue are now gray! If you have any ideas -
would deeply appreciate it.

thanks
sp

 

[Chip Pearson]

Excel takes its colors from the application's default color
pallet unless the workbook has its own, in which Excel uses that
pallet. Let's say in the workbook dark blue had been assigned to
Colors(40). That means anything whose ColorIndex property was set
to 40 will appear in dark blue. Then, you reset the color pallet.
The object still uses Colors(40), but in the default pallet this
is gray; therefore, anything that used Colors(40) will appear
gray. You'll have to manually change the ColorIndex property to
get the color you want.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Can you comment on whether this may be something that might be changed in
future versions? I experience this problem all of the time and I'm finding
that recipients of my Excel attachments cannot read data in cells because the
colors on their view are different than mine.