Sometimes I receive an excel worksheet from other users and the default color
palette is different to mine. Eg My default palette has Rose as the bottom
LH corner. On the workbooks I receive this colour is a bright pink and many
of the base colours are missing (eg no yellows).

When I hover my mouse pointer over the colour the pop up just says "colour
Scheme" and not the true colour.

I guess that the change is due to the originator using a different version
of Excel to mine (2003) but is there a way of resetting the palette to
default to access the full colour range?