In Windows 10, Excel color fill quit displaying today 10/1/17 but prints fine.

%3CLINGO-SUB%20id%3D%22lingo-sub-112450%22%20slang%3D%22en-US%22%3EIn%20Windows%2010%2C%20Excel%20color%20fill%20quit%20displaying%20today%2010%2F1%2F17%20but%20prints%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-112450%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20determining%20my%20MS%20Windows%2010%20does%20not%20have%20the%20high-definition%20turned%20ON%2C%20I'm%20at%20a%20loss%20as%20to%20why%20the%20fill%20color%20on%20my%20spreadsheets%20won't%20display%20but%20will%20print%20fine.%26nbsp%3B%20This%20started%20happening%20after%20the%20last%20update%20and%20I'm%20wondering%20if%20anyone%20else%20is%20having%20this%20problem%20and%20if%20someone%20has%20found%20a%20solution.%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-112450%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1858661%22%20slang%3D%22en-US%22%3ERe%3A%20In%20Windows%2010%2C%20Excel%20color%20fill%20quit%20displaying%20today%2010%2F1%2F17%20but%20prints%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1858661%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F86125%22%20target%3D%22_blank%22%3E%40George%20Michaels%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edid%20you%20ever%20get%20this%20fixed%3F%26nbsp%3B%20I%20have%20the%20exact%20same%20problem.%26nbsp%3B%20Techs%20at%20MS%20tried%20to%20help%20via%20chat%20and%20also%20I%20am%20in%20contact%20with%20another%20person%20via%20messenger%20board.%26nbsp%3B%20Please%20reply%20if%20you%20are%20able.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114945%22%20slang%3D%22en-US%22%3ERe%3A%20In%20Windows%2010%2C%20Excel%20color%20fill%20quit%20displaying%20today%2010%2F1%2F17%20but%20prints%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114945%22%20slang%3D%22en-US%22%3E%3CP%3EBarbara%2C%20I%20have%20exactly%20the%20same%20problem.%26nbsp%3B%20Not%20just%20the%20FILL%20color%2C%20but%20no%20colors%20at%20all%20except%20fonts%2C%20(which%20always%20appear%20black)%26nbsp%3B%20placed%20anywhere%20on%20my%20Excel%202013%20spreadsheet%20display%20on%20my%20monitor%20screeen.%26nbsp%3B%20However%2C%20they%20do%20show%20up%20correctly%20on%20paper%20when%20I%20print%20it.%26nbsp%3B%20I%20am%20at%20a%20loss%20for%20the%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114233%22%20slang%3D%22en-US%22%3ERe%3A%20In%20Windows%2010%2C%20Excel%20color%20fill%20quit%20displaying%20today%2010%2F1%2F17%20but%20prints%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114233%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20the%20same%20exact%20problem.%20It's%20important%20that%20I%20view%20my%20sheets%20in%20page%20view%20so%20I%20can%20make%20sure%20all%20the%20header%20and%20footer%20fields%20are%20visible.%26nbsp%3BHoping%20for%20a%20fix%20ASAP%2C%20as%20this%20is%20driving%20me%20NUTS!%20It%20also%20only%20started%20this%20week%20for%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-112637%22%20slang%3D%22en-US%22%3ERe%3A%20In%20Windows%2010%2C%20Excel%20color%20fill%20quit%20displaying%20today%2010%2F1%2F17%20but%20prints%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-112637%22%20slang%3D%22en-US%22%3E%3CP%3EMS%20advised%20making%20sure%20the%20latest%20version%20and%20all%20updates%20are%20installed.%26nbsp%3B%20When%20I%20checked%2C%20I%20have%20the%20latest%20version%20installed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20get%20this%20resolved%20I%20called%20support.%26nbsp%3B%20We%20tried%20to%20%22repair%22%20MS%20Office%20from%20Programs%20and%20Changes.%26nbsp%3B%20This%20failed.%26nbsp%3B%20We%20uninstalled%2Freinstalled%20MS%20Office.%26nbsp%3B%20We%20found%20my%20existing%20Excel%202016%20spreadsheet%20will%20display%20Fill%20Color%20in%20the%20%22normal%22%20and%20%22page%20break%20preview%22%20views%20but%20NOT%20the%20%22page%20layout%22%20view.%26nbsp%3B%20WORKAROUND%3A%26nbsp%3B%20Don't%20use%20%22page%20layout%22%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20year%20I've%20been%20using%20this%20particular%20spreadsheet%20on%20a%20weekly%20basis.%26nbsp%3B%20I%20open%20the%20previous%20week%20and%20%22save%20as%22%20for%20the%20new%20week.%26nbsp%3B%20For%2038%20weeks%20it%20has%20worked%20in%20the%20%22page%20layout%22%20view.%26nbsp%3B%20Now%20it%20doesn't.%26nbsp%3B%20Is%20it%20the%20file%3F%26nbsp%3B%20Or%20did%20MS%20Office%20getting%20updated%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOpening%20a%20new%20worksheet%2C%20everything%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20engineers%20will%20look%20at%20this.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20quick%20response.%26nbsp%3B%20Much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-112569%22%20slang%3D%22en-US%22%3ERe%3A%20In%20Windows%2010%2C%20Excel%20color%20fill%20quit%20displaying%20today%2010%2F1%2F17%20but%20prints%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-112569%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Barbara%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20that's%20for%20Page%20Layout%20view%20when%20that's%20the%20bug%20which%20is%20fixed%20for%20later%20builds%2C%20please%20see%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2FFixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093%3Fui%3Den-US%26amp%3Brs%3Den-GB%26amp%3Bad%3DGB%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2FFixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093%3Fui%3Den-US%26amp%3Brs%3Den-GB%26amp%3Bad%3DGB%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

After determining my MS Windows 10 does not have the high-definition turned ON, I'm at a loss as to why the fill color on my spreadsheets won't display but will print fine.  This started happening after the last update and I'm wondering if anyone else is having this problem and if someone has found a solution.  Thank you!

7 Replies

Hi Barbara,

 

If that's for Page Layout view when that's the bug which is fixed for later builds, please see

https://support.office.com/en-gb/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows...

MS advised making sure the latest version and all updates are installed.  When I checked, I have the latest version installed.

 

To get this resolved I called support.  We tried to "repair" MS Office from Programs and Changes.  This failed.  We uninstalled/reinstalled MS Office.  We found my existing Excel 2016 spreadsheet will display Fill Color in the "normal" and "page break preview" views but NOT the "page layout" view.  WORKAROUND:  Don't use "page layout" view.

 

All year I've been using this particular spreadsheet on a weekly basis.  I open the previous week and "save as" for the new week.  For 38 weeks it has worked in the "page layout" view.  Now it doesn't.  Is it the file?  Or did MS Office getting updated?

 

Opening a new worksheet, everything works.

 

The engineers will look at this.  

 

Thank you for your quick response.  Much appreciated.

 

I'm having the same exact problem. It's important that I view my sheets in page view so I can make sure all the header and footer fields are visible. Hoping for a fix ASAP, as this is driving me NUTS! It also only started this week for me.

Barbara, I have exactly the same problem.  Not just the FILL color, but no colors at all except fonts, (which always appear black)  placed anywhere on my Excel 2013 spreadsheet display on my monitor screeen.  However, they do show up correctly on paper when I print it.  I am at a loss for the solution.

@George Michaels 

 

did you ever get this fixed?  I have the exact same problem.  Techs at MS tried to help via chat and also I am in contact with another person via messenger board.  Please reply if you are able.

We recently updated to Windows 10 and that's when I noticed that the color fill function in Excel would not work.  I've tried looking up fixes for this issue online but thus far, I have not been able to get this issue fixed.  I'm constantly using this function to highlight different cell data and it's frustrating that I can't find a fix - please help @Barbara Hansen 

You are not alone - this just started happening with my work version of Excel @Terry_Carroll 

 

In cell to be colored I apply the following work-around

Right click in designated cell

Select Format Cells

Select the Fill tab

Choose color

Select OK button

 

Sometimes this action will trigger the fill color in the bucket icon.  Today that is not even working for me.

 

Hope this helps.