Excel 2003 color palette changes?

[jared511]

I am not sure if anyone else has experienced this before but for some reason when I am in some of my spreadsheets, the background colors for the cells have changed. In fact the entire color selections are slightly different from what is normal. Then if I close out all sheets I have opened and reopen them in excel they are back to normal. Any ideas on what causes this?


Thanks,
Jared

 

[Andrew Poulsom]

A workbook can have its own modified colour palette. To reset to the default choose Tools|Options|Color tab, click Reset then OK.

 

[jared511]

Hmm for some reason it isn't working. I opened up two different sheets each with different color schemes and tried copying one to another but they do not change. I also tried resetting both and neither change.. Any ideas?


Thanks again!

 

[jared511]

Its also interesting to note that regardless of which of the two sheets I open first, they both change to the color scheme I do not want to use.. Not sure if that helps or not..

 

[Andrew Poulsom]

I can't reproduce your problem (Excel 2000). But apparently SAP can cause it:

http://www.eggheadcafe.com/software/aspnet/32848091/collor-pallet-changes-unw.aspx

 

[jared511]

Ah do you mean ASAP? I can't access that link right now from work but that would explain it. I do have that installed. I manually changed all the colors to fix the issue lol.. Thanks again!

 

[Andrew Poulsom]

No not ASAP (Utilities), but SAP (Business Management Software).

 

[jared511]

Ah ok.. I don't use that.. But thanks again for the info

 

[xld]

It is possible to have two entirely different colour palettes in one workbook. You have to have multiple windows to achieve it, but whatever way you look at it, it looks like a bug to me.

 

[ZVI]

Hi Jared,

It's known issue, see details here: Excel highlight color changes between sessions

Direct link to my add-in (free) which solves this issue: ZVI_TrueColors.zip

Regards,
Vladimir