Pivot table fields text color

%3CLINGO-SUB%20id%3D%22lingo-sub-3045265%22%20slang%3D%22en-US%22%3EPivot%20table%20fields%20text%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3045265%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20know%20why%20the%20text%20color%20of%20the%20pivot%20table%20fields%20change%20to%20white%20and%20how%20do%20I%20change%20it%20back%20to%20black.%26nbsp%3B%20It%20is%20very%20difficult%20to%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Garth2039_0-1640282757025.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F335776i26679D3AB2156861%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Garth2039_0-1640282757025.png%22%20alt%3D%22Garth2039_0-1640282757025.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3045265%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I would like to know why the text color of the pivot table fields change to white and how do I change it back to black.  It is very difficult to see.

 

Garth2039_0-1640282757025.png

Thanks.

13 Replies

@Garth2039 

Looks like a bug. You may try to update Office.

@Sergei Baklan 

According to my Office software I am current with all Office updates.

 

@Garth2039 I have this white-font issue as well, but I started seeing it a few weeks ago.

 

Unfortunately, I haven't been able to find a solution to this yet.

@Garth2039 Just happened to me today, 12/29/21.  Hopefully they will push out an update to fix soon.

I did find a work around, I had my theme set to dark gray when the font suddenly change to white on gray in the fields, if you choose any other theme, there is a nice contrast. Not a total win since I prefer the dark gray but at least I can see my field now.
Thanks for the info. I will make the change you describe. Like you I prefer the dark grey theme but I would prefer to to be able to see the text.

This is a problem for our analysts. Dark Gray is great for their eyes, but they work in pivot tables ALOT and would prefer not to change their office theme just for Excel pivot tables. It almost seems like this was just an "oversight" in the development of the new theme. The other font is black and very readable. Microsoft - please roll out a fix!! For the sake of the sanity of our analysts.

@missyllane 

That is Dark Gray in my case

image.png

On which channel and build you are?

@Sergei Baklan That Dark Gray looks nice.  Ours has white font in the 4 quadrant dimensional panels under the field list.  (I lost the screenshot - but it was identical to the one seen at the top of this topic.

 

Monthly Enterprise Channel

Version 2111 (Build 14701.20290 Click-to-Run)

@missyllane 

I see, thank you. I'm on Current Preview, thus later builds.

 

Not exactly the same but similar issue was discussed here Re: Excel theme black and font list - Microsoft Tech Community, it disappeared with build 14729.20038. Hope your one will be resolved with nearest update(s).

 

In any case, I'd recommend to report an issue from Help->Feedback within Excel. Don't expect an answer, but Microsoft monitors such feedbacks and takes proper actions.

Just checked after doing updates and the dark gray theme has the black lettering back on the pivot tables now!! Woo hoo!
I just checked today after doing updates, and dark gray is fixed back to a black font!

@KSmith_ 

Great to know, thank for sharing