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

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


wrote in message
oups.com...
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

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 wrote:
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


wrote in message
oups.com...
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

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

wrote in message
oups.com...
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 wrote:
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


wrote in message
oups.com...
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

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.

"Chip Pearson" wrote:

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

wrote in message
oups.com...
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 wrote:
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


wrote in message
oups.com...
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