Question description:
This user has given permission to use the problem statement for this
blog.
The pivot table on Tables tab will not refresh with the entire spread sheet data on 2nd tab.
Solved by S. F. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
17/08/2018 - 06:21
Hi
User
17/08/2018 - 06:22
Here is the spread sheet
[Uploaded an Excel file]
User
17/08/2018 - 06:22
hello
Excelchat Expert
17/08/2018 - 06:22
Give me a minute. I am downloading the file
User
17/08/2018 - 06:22
ok
Excelchat Expert
17/08/2018 - 06:25
The excel is corrupted
User
17/08/2018 - 06:25
That doesn't sound good
Excelchat Expert
17/08/2018 - 06:26
Let me retry and see
User
17/08/2018 - 06:26
OK, thank you
Excelchat Expert
17/08/2018 - 06:29
The file is open now :)
Excelchat Expert
17/08/2018 - 06:29
Can you give me an example of what you want to refresh?
User
17/08/2018 - 06:30
The whole pivot table should refresh with all of the 2018 data.
User
17/08/2018 - 06:31
the total should change from 685 to include all of the 2018 data
Excelchat Expert
17/08/2018 - 06:31
Ok. I guess currently it is showing error. Is it correct?
User
17/08/2018 - 06:32
Yes, when I try to refresh the pivot it tells me "Reference isn't valid'
Excelchat Expert
17/08/2018 - 06:32
ok
Excelchat Expert
17/08/2018 - 06:33
Also, currently the output (Tables tab) shows data irrespective of the data. Do you want it to be shown for only 2018?
User
17/08/2018 - 06:34
No, it is a fiscal year data so it should have some 2017 and 2018 data
Excelchat Expert
17/08/2018 - 06:34
ok
Excelchat Expert
17/08/2018 - 06:35
Give me a moment. It is almost done
User
17/08/2018 - 06:35
ok, thank you!
Excelchat Expert
17/08/2018 - 06:37
Here it is :)
[Uploaded an Excel file]
Excelchat Expert
17/08/2018 - 06:39
Hi. Are you there?
User
17/08/2018 - 06:39
Looks and works great! Thank you so much!!
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.