April 9, 2024
Contribute to the Microsoft 365 and Office forum!
Click here to learn more 💡
May 10, 2024
Excel Forum Top Contributors:
Missing column from table in Pivot Table field
Report abuse
Thank you.
Reported content has been submitted
You probably need to click Refresh. The Pivot Table Field List does not automatically update. Right-click the pivot table and choose Refresh
If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire
Report abuse
Thank you.
Reported content has been submitted
311 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
HTH,
Bernie
MS Excel MVP
<wildcat97> wrote in message news:*** Email address is removed for privacy *** .com...I have a table that is used as for reporting that I create numerous PivotTabels from. I have inserted a column in the table but when I insert the Pivot from the table, my new column is not given to me as an option in the PivotTable Field List. The only way I have gotten this to work is by removing the table formatting which I do not want to do. Any suggestions on what I'm missing here? Thanks in advance for any help with this!
Report abuse
Thank you.
Reported content has been submitted
57 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated May 13, 2024 Views 103,181 Applies to: