Struggle to make a calculated field appear in a PivotTable

I had a calculated field in a table that I was using to populate a PivotTable. All the other fields appeared in the field list, but no matter what I did, the calculated field wouldn’t show up. Refreshing, closing and opening the file didn’t work, exiting and re-launching Excel didn’t work. What finally worked: closing Excel and leaving the computer alone for a day. The following day, the field appeared in the list and I was able to use it in the PivotTable. Weird.

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Get in touch