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.

 

[RoryA]

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

So that people don't go changing the original question, thereby making follow up posts or questions meaningless.

 

[niko333c]

Yes. We tried more files. All existing workbooks, all colors: all cells backgrounds appear white but they should be colored.

Only if we create a brand new workbook and color a cell, it becomes colored and remains so.

Calling an exorcist?

 

[JayBurn]

Hmm... have you tried turning it off, then turning it back on again?

Has your PC switched power supply to be powered by the influence of a grumpy cat?

... wait, did you recently insult Bill Gates in public?

Can you give us a screenshot without giving out confidential data?

 

[JayBurn]

Actually, a more sensible answer...

Do the existing workbooks get updated by Business Intelligence software that produces Crystal reports exported as Excel sheets? I used to have an issue in my old business where Crystal reports would import into Excel with some bonkers formatting and I could never get it fixed.

 

[niko333c]

Wow, I don't know what that Crystal thing is!

LOL, it's always cats when something is messed up! :D

Yes the computer was restarted already. It started acting since yesterday.

It seems like ONE excel file is NOT being affected by the issue, and we can see all the colors of all the cells.

Attaching screenshots:



see comments on each one.

HOW do I attach the JPEGs??

Ah I see your point with the 10 minutes modification policy. Then developers should add a function to only add update sections to the original post, without being able to modify the post already written. What about it?

 

[JayBurn]

I notice you skipped over insulting Bill Gates in public... we can safely assume that's the problem.

To attach images you need to host them somewhere; there are hundreds of sites that offer free hosting. Then you just hit the insert image button and drop in the image URL.

Are the squiffy workbooks in an older file format, or touched by any other spreadsheet program?

 

[niko333c]

I notice you skipped over insulting Bill Gates in public... we can safely assume that's the problem.

LOL

Okay so here is the drive link with the 4 pictures:

https://drive.google.com/drive/folders/0B9S5--gDP_0hRGdqSmNEdDR4SE0

 

[JayBurn]

Bottom right corner, switch to Normal view rather than Page Layout... see if that makes any difference? A quick Google shows a few people having issues with Page Layout view screwing things up.

p.s. Love the paint skillz.

 

[niko333c]

LOL thanks! How did you know I used paint?

That's good idea thanks! However, for months until 2 days ago there were no problems.... Let's see....

WOW IT WORKS!!!

Thanks so much!!!!!

Love the google skills... curiosity: do you remember exactly what keywords did you google for such a thing?

Thanks

 

[thisoldman]

Too late–I'm too slow.