Pivot Table not refreshing properly

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,655
Office Version
  1. 365
Platform
  1. Windows
I have a PT based on a table of data that contains the following fields/columns
* Run - This is the name of a delivery route
* Week Comm - This is the week com date in which the Run will occur

The Run field is used as a filter for the PT rather than being 'in' the PT
1739530700292.png


First problem is that in the PT filter drop-down the values are not in alphabetical order

The option for Custom lists in the totals & Filters option is set to off
1739531168504.png


The when I click on the drop-down for the list of each Run, the list shows values that don't exist in the source data
1739530767519.png


Specifically, the GATE run is not in the source date. It may have been previously and removed, but as of now it does not exist.

Below is a screen shot of the source date with a filter open showing all unique Run entries
1739530875268.png


As you can see GATE is not there.

Second problem is when I make a selection of a Run in the PT filter for example SWEST (which does exist in the source date), the PT shows rows from the source date that do not have the SWEST entry in the Run column.

So the PT is showing filter options that don't exit and when an option that does exit is selected, it returns entirely incorrect data.

FYI - The Data option for the number of items to retain is set to None
1739531047282.png


TIA of any advice anyone can provide.
 
I'd start by making sure the source data for the pivot table is actually what you think it is, then make sure the data is refreshed. Beyond that there really isn't a lot to say without the file.
 
Upvote 0
I'd start by making sure the source data for the pivot table is actually what you think it is, then make sure the data is refreshed. Beyond that there really isn't a lot to say without the file.
100% positive the source data is correct and the PT is linked to that data.

Unfortunately I can't share the file as it is a clients file with confidential sales data.......

I am going to rebuild the PT and keep an eye on it. It will get flagged quickly if it happens again but fingers crossed it won't......
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top