Pivot Table Filter Macro Not working

I am trying to speed up a pivot table filter of over 15000 items.

I have been advised to add the code line "pt.ManualUpdate=True" which is now preventing it from running at all - Runtime Error 91, Object variable or With block variable not set.

Has anyone got any suggestions of how to fix it but get the filter to run quickly, without any modification it takes around 4 mins to filter the report.

Please Login or Register  to view this content.

While you have declared pt as a Pivottable object, you have not set pt to be the pivot table in your sheet.

Try

Please Login or Register  to view this content.

after you select the sheet.

Solved. Thanks MRice