I created a spreadsheet that used a color scheme that was copied from
another spreadsheet that I had downloaded from a microsoft website. I
recently opened that spreadsheet while I had a new one open and it
converted the colors in the new one to be the same. I did not want
this color scheme for my new spreadsheet and I was unable to reset the
colors to the default.

So basically what is happening is that if I open this spreadsheet with
a custum color scheme, while another spreadsheet is open, it converts
all the color schemes to the custom one. If the spreadsheets are then
saved, they are stuck with that color scheme. I am not able to reset
the colors using toolsoptionscolor tabReset. It doesn't do
anything.

I am extremely frustrated and by looking at similar posts, it doesn't
that there is much knowledge about this subject. I would appreciate
any help I can get.

Thanks,

Jacob

Hi Jacob,

In theory the scenario you describe cannot occur. A custom palette is only
saved within the workbook and does not affect Excel's default palette or any
other workbooks.

A long shot might be if the wb you downloaded had a 'default' palette of a
pre xl97 version, can cause some odd things in rare circumstances, as I
understand.

Post back if you are still having problems.

Regards,
Peter T

wrote in message
ups.com...
I created a spreadsheet that used a color scheme that was copied from
another spreadsheet that I had downloaded from a microsoft website. I
recently opened that spreadsheet while I had a new one open and it
converted the colors in the new one to be the same. I did not want
this color scheme for my new spreadsheet and I was unable to reset the
colors to the default.

So basically what is happening is that if I open this spreadsheet with
a custum color scheme, while another spreadsheet is open, it converts
all the color schemes to the custom one. If the spreadsheets are then
saved, they are stuck with that color scheme. I am not able to reset
the colors using toolsoptionscolor tabReset. It doesn't do
anything.

I am extremely frustrated and by looking at similar posts, it doesn't
that there is much knowledge about this subject. I would appreciate
any help I can get.

Thanks,

Jacob

Peter,

I have not yet resolved the problem. I don't think the workbook I
downloaded was from an older version. I can't verify that though. I
don't even have that workbook anymore. I can send you the spreadsheet
if you think that would help.

Thanks,

Jacob

Take a look at this long thread over in excel.misc

http://tinyurl.com/oukrh

At the time the OP's problem wasn't solved. But I recall a few months later
the OP posting back with how she eventually did get it fixed. For some
reason I can't find that subsequent follow-up but think it was in July 2004,
also as I recall it was attached to the original thread. Not sure why it's
no longer there in my search but if you find it post the link.

You can forward the workbook (stripped without macros) but I suspect the
problem is related to your overall setup, if so I would not be able to
reproduce the reset palette problem.

Regards,
Peter T

pmbthornton gmail com


"Jacob" wrote in message
ups.com...
Peter,

I have not yet resolved the problem. I don't think the workbook I
downloaded was from an older version. I can't verify that though. I
don't even have that workbook anymore. I can send you the spreadsheet
if you think that would help.

Thanks,

Jacob