Cells fill color apparently disappears (only on pre-existing files)

[niko333c]

Hello everybody,

this is new!

You know, sometimes Excel feels a little nostalgia of those moments when he drives you nuts, and decides to reiterate.

What about this time?

Since yesterday he decided to not to show cells fill color anymore, but!

• Only if you open pre-existing Excel files. If you create a new one, he shows you all the colors you want
• As soon as you open whatever pre-existing Excel file, the first fraction of a second it shows the colors of the cells, but then the color immediately disappear and the cells become white
• If you right click properties fill on any cell, it shows the preview of the color of the cell fill correctly in the window, but not in the real cell
• Sometimes, for example if you mouse-scroll, all the cells that are supposed to be colored (but appear white), became all completely black
• If you try to re-set the color of the cell or change color, for a fraction of a second it shows the color of the cell fill (just when you click on the color icon on the toolbar), but then the color of the cell fill immediately disappears and becomes white
• Other cells are fine, for example the header line of the table, which fill is light purple. Blue or yellow cells? Forget it!
• You can do whatever you want, even smash your head on the screen repeatedly the cells stay white

All other Windows colors are fine, MS Word colors are fine, even new Excel files' cells' filling colors are fine.

Any clue of what spirit just possessed it?

Thank you.

 

[JayBurn]

Without sounding condescending, are you sure you're not opening CSV files?

 

[niko333c]

Thanks Jay.

Oh yeah, it's always the same files and records we use here.

Furthermore, this is only happening to a Win 10 laptop. With my laptop every file is fine.

Thanks

 

[RoryA]

Bit of a long shot, but you don't have a High Contrast theme set in Control Panel do you?

 

[niko333c]

Don't worry Rory, when dealing with Excel, long shots are welcome :D

No, High Contrast was off. We tried both ways after, but it didn't change.

thanks.

 

[JayBurn]

Jump into your Excel options, go to Advanced, and try Enabling/Disabling hardware graphics acceleration?

 

[niko333c]

Interesting... tried.... nothing. Same issue.

Adding another hint in the initial thread post: "thin line color".

That was a good shot though!

Thanks Jay.

 

[JayBurn]

Hmm... tricksy.

Anything looking odd in the Themes, Colours or Effects under Page Layout?

 

[niko333c]

good point: checked, played with them. Nothing changes!

I couldn't modify the initial post as it's only allowed for 10 minutes (!! by the way why???). So, adding update here:

UPDATE

It looks like some kind of graphic imperfection/defect (like you know when video card drivers go nuts?), because sometimes if I try to color cells, it shows white but sometimes it shows a very thin line of that color I used, only at the very bottom of the cells. But not always.

Or it kind of changes when zooming in/out...

But it can't be a graphic defect, as new Excel files are totally fine. It only affects existing ones!

Thanks

 

[JayBurn]

So you say it's on existing workbooks... is it on ALL existing, or a specific set of workbooks?

If it's on some specific workbooks, is it possible that your data is in a table rather than a normal dataset? if it's a table then the table format will override the cell format.