Pivot Table problem with MissingItemList

G

Graham Y

I found this really handy piece of code in this forum earlier today, and it
fixed my problem, the PivotTable was retaining old data in its drop down
lists.
I added this code and all was fine.

With ActiveSheet.PivotTables("WL")
.PivotCache.MissingItemsLimit = xlMissingItemsNone

That is until I gave it to someone else to use and now it causes an error, I
have on error goto reset defaults, which it does.
I've checked the other machine for updates and it is up to date, I've
checked the references and they match.
But now I am unsure where else to look.
How do I check why the line causes the error?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Pivot Table Error 1
Refresh all Pivots and delete old background data 2
Problem with SET & REF function 0
Working outlook via vba code with xlsx - error 0
Doughnut Chart linked with the slicer in the pivot table 0
Playing back a Pivot Table macros 2
delete selection in pivotcolumn 3
Dealing with a Pivot Table (when I don't want to) 0

Top