Pivot table Cache clear

**magnus101** · 09-21-2012, 12:58 PM

Hello,
It seems like a pivot table has some kind of cache and I am wondering how to clear it.

For example,

I have a table like:

Project Date completed
aa 1-1-2012 100
bb 1-1-2012 200

Than attach a pivot table to it.

Row labels = date
Column labels = project
values = sum of completed

then change aa to cc

In the pivot table all aa, bb and cc are listed.
when there really is no aa any more.

is there a way to delete the cache.

Chart test2.xlsx

I have attached a sample.

thanks

**Domenic** · 09-21-2012, 07:48 PM

I haven't looked at your sample file, but you only need to select a certain option for the pivot table, and then refresh the pivot table. Try the following...

With a cell selected within your pivot table, select the Options tab on the ribbon.
In the PivotTable group, select Options.
In the dialog box, select the Data tab.
For "Number of items to retain per field", select None, and click OK
In the Options tab on the ribbon and in the Data group, click on Refresh.

Actually, a shortcut to the dialog box for PivotTable Options would be to right-click a cell within your pivot table, select PivotTable Options, etc.

**Toptrader8** · 10-24-2024, 04:23 PM

I am having the same problem. Tried the solution provided but still no joy.

**AliGW** · 10-25-2024, 02:06 AM

Administrative Note:

We are happy to help, however whilst you feel your request is similar or even the same as this thread, we have a rule that you open your own thread on the issue and do not piggy back another member's thread.

Please see Forum Rule #1 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread