Excel (2003) Weird Shit

Not a big deal but freaky nonetheless. The color pallet for my fill colors (and font and line colors) has gone all hay wire on one file. I build a lot of big spreadsheets and use fill color to distinguish groups of data. I created a file yesterday and when I went to the fill color tab I noticed it was all weird. It has four or five white options, four or five blacks and the color pallet is all random instead of the usual progressive order. Not a big deal since I still have multiple colors to choose from.

But curious I opened some other files to see what they look like and they all have the weird color pallet and cells are different now than what they were yesterday. All my files have the same wrong pallet. Closed the files, shut down and restarted. Pull up some old files – everything looks good. Open the new file – weird colors. And now all the old files I have open (or that I go open) now have the same weird pallet. If I go into excel and open only old files everything looks okay – but as soon as I open the new file everything changes. There seems to be no way to fix the one file to get it to use the right pallet or not corrupt the other files. I guess I can just delete the file and start over but it’s big and has a lot of data. If I try to copy the data to a new file it just starts off with the wrong pallet. I can still work with the file but I can’t have any others open at the same time. In some cases the fill color in old files is black and data isn’t visible. Pain in the ass.

Anybody ever see such a thing?

 

Have you tried importing the color palette from a workbook that looks correct?

 

I’ll play dumb for a minute. By import do you mean go
Tools > Option > Color
Copy color from

Where I can select to copy colors from another open file? That’s the only way I know to do it. Of course that means I must have the corrupt file open to copy to and a good file open to copy from. Problem is every open file that had a good color pallet is corrupted and changed as soon as I open the bad file.

Apparently it is from a file I opened from an e-mail attachment. It has the corrupt color pallet in it. These files were created by someone at our Israeli parent. Not sure if that is the issue or not since most files from there are fine.

For now it’s just a minor annoyance. More concerned with our server that keeps crashing. At least internet is working...

 

There is a little bit of changes there in 2007 compared to 2003...

_____________

Whey Protein
Protein Supplements