Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I added data to my table. Ive refreshed the pivot table but when I access "builder" within the table, I don't see my new column listed.
Solved by B. C. in 39 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 13/09/2018 - 09:38
Welcome to excelchat, I see your question is about pivot table help.
Excelchat Expert 13/09/2018 - 09:38
I can help you with the problem. I'll also provide a full explanation of the solution.
Excelchat Expert 13/09/2018 - 09:39
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 13/09/2018 - 09:40
Let me ask you a couple of quick questions to make sure I fully understand your problem. So, let's get started when you are ready.
User 13/09/2018 - 09:40
ready
Excelchat Expert 13/09/2018 - 09:40
Great!
Excelchat Expert 13/09/2018 - 09:41
You are tying to add a new column to pivot table?
User 13/09/2018 - 09:41
yes
Excelchat Expert 13/09/2018 - 09:41
Can I see the file for reference?
User 13/09/2018 - 09:42
how
Excelchat Expert 13/09/2018 - 09:42
You can upload the file by clicking on the paperclip icon.
Excelchat Expert 13/09/2018 - 09:45
Are you uploading the file? If you can't I understand that.
User 13/09/2018 - 09:46
i did
Excelchat Expert 13/09/2018 - 09:47
Sorry, I don't see a file.
Excelchat Expert 13/09/2018 - 09:48
Okay, we can work without the file if you are having trouble uploading it. Just let me know.
User 13/09/2018 - 09:48
ok
User 13/09/2018 - 09:48
icant understand it. i clicked on the clip and chose the file
Excelchat Expert 13/09/2018 - 09:48
Please answer this, how many columns do you have in source data?
Excelchat Expert 13/09/2018 - 09:49
After choosing the file, you have to press Enter from keyboard.
User 13/09/2018 - 09:49
15
Excelchat Expert 13/09/2018 - 09:50
And where did you add new data?
User 13/09/2018 - 09:50
the last column
Excelchat Expert 13/09/2018 - 09:51
You mean you added an extra column at the end?
User 13/09/2018 - 09:51
yes
User 13/09/2018 - 09:52
I added it to the print area too
Excelchat Expert 13/09/2018 - 09:52
Just to make sure we are on the same page, you added an extra column at the end of your source table and that column is not showing up in pivot table builder.
Excelchat Expert 13/09/2018 - 09:52
Do you believe that will address your problem?
User 13/09/2018 - 09:52
thats the problem
User 13/09/2018 - 09:53
that is the problem
Excelchat Expert 13/09/2018 - 09:53
Alright, please follow the instructions I'm giving. Also you need to select YES if you are asked to extend time so that the chat doesn't end after 4 minutes.
Excelchat Expert 13/09/2018 - 09:53
1. Select any cell in the pivot table. let me know when done.
User 13/09/2018 - 09:54
yup
User 13/09/2018 - 09:54
done
Excelchat Expert 13/09/2018 - 09:55
2. On the Ribbon, click the Analyze tab. Let me know when done.
User 13/09/2018 - 09:56
i don't see that option
Excelchat Expert 13/09/2018 - 09:57
You are using excel, right?
User 13/09/2018 - 09:57
yes
Excelchat Expert 13/09/2018 - 09:57
Please give me a sec, I'm sending a screenshot.
User 13/09/2018 - 09:58
tx
User 13/09/2018 - 09:58
tx
Excelchat Expert 13/09/2018 - 09:58
[Uploaded an Excel file]
Excelchat Expert 13/09/2018 - 09:59
Analyze is marked inside the black oval icon.
Excelchat Expert 13/09/2018 - 10:00
Have you found it yet?
Excelchat Expert 13/09/2018 - 10:03
When you find the Analyze tab, click on it then click on Change Data Source.
Excelchat Expert 13/09/2018 - 10:04
You will see a pop up dialogue box, here select the source data again including the new column. Then click on OK to finish.
Excelchat Expert 13/09/2018 - 10:05
The pivot table will automatically refresh and you would also be able to see the new column added to builder.
Excelchat Expert 13/09/2018 - 10:05
Does this solution solve your problem?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.