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.
