Refresh PivotTable Data Field List

[Keith N]

Okay, I need some help please.

I have a pivot table that has a source from a sheet within the same
workbook. I have added a couple of rows to the source and then reset the
pivot table to accept the additional rows. Next I edited one of the fields
information from "foo" to "foobar". This same field can be used in
filtering by choosing the combo box and checking the specific info.
However, I noticed that my combobox shows both "foo" and "foobar". I can
check "foo" and nothing comes up.

I have down Refreshes both coming into the workbook and by right clicking
and choosing refresh. Nothing seems to clear out the cache.

I moved the data field to the page field section. My combobox shows the
right info. However, when I drag it back down as a data field, all of the
same cache remains again.

How do I get the data field combo boxes to clear without doing a macro?

Peace,
Keith

 

[Luc.Heyndrickx]

Keith,

Add-Inn ?
http://users.skynet.be/onderland/Excel.htm
15- PivotCleaner

Luc

 

[immanuel]

You might want to try unchecking "Save Data with Table Layout" in the
PivotTable Options dialog. Save the workbook, close it, and then reopen it.
Excel should rebuild the cache. (You may wish to check "Save Data..." after
the refresh to improve performance of future loads.

/i.

 

[immanuel]

Further to my earlier post, check out
http://support.microsoft.com/default.aspx?scid=KB;EN-US;104308 for details
on the impact caching has on PivotTable performance...

/i.

 

[Keith N]

I gave it a try. When I reopen the file and I choose the dropdown, I am
prompted to refresh. I do the refresh. Then I choose the drop down and all
the data is there again.

Any other suggestions?

Peace,
Keith

 

[Keith N]

This sounds like an idea. But the developer in me wants to know why it does
this. My concern is sending the information to a client and them having the
same problem.

Peace,
Keith

 

[immanuel]

Some more info:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;202232

/i.