Pivot Table Filter Macro Not working

**sm9748** · 08-22-2013, 10:08 AM

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.

**mrice** · 08-22-2013, 01:49 PM

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.

**sm9748** · 08-23-2013, 03:43 AM

Solved. Thanks MRice

Pivot Table Filter Macro Not working

LinkBack

Thread Tools

Rate This Thread

Display

Pivot Table Filter Macro Not working

Re: Pivot Table Filter Macro Not working

Re: Pivot Table Filter Macro Not working

Thread Information

Users Browsing this Thread

Similar Threads

Macro that would filter pivot table top 10 items

VBA Pivot Table Filter Macro

Macro to filter Pivot Table by range

Macro Help Needed - Link Pivot Table Filter to Regular Table AutoFilter

Macro to filter Pivot not working

Bookmarks

Bookmarks

Posting Permissions