Excel - How to Refresh Pivot Tables - Expert Solution

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
User 17/08/2018 - 06:22
Here is the spread sheet
[Uploaded an Excel file]
User 17/08/2018 - 06:22
Excelchat Expert 17/08/2018 - 06:22
Give me a minute. I am downloading the file
User 17/08/2018 - 06:22
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
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
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.

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc