Apply Pivot Table Maual Update =True

**meus** · 09-23-2015, 11:47 PM

Hey all

I am trying to speedup my macro linked with several Pivot tables. I have come with a code to make pivot Macro faster but i was wondering if the following codes can be minimized or is correct or not.. or is there any way to make it more better...

Please Login or Register  to view this content.

I have four Pivot table i.e 1,2,3 and 4 and first set pivot table to manual and then code and at last manual update false... Is it correct that i used above??
Or any Better way?
Thanks

**NeedForExcel** · 09-24-2015, 12:12 AM

Hi,

Instead of having individual lines, you can loop through collections.

Something like

Please Login or Register  to view this content.

**meus** · 09-24-2015, 12:23 AM

Thanks For reply...
Before i was using..

Please Login or Register  to view this content.

But from your code, it has become more slow than before.. Why is it so.. Pissed off..

Thanks.

**NeedForExcel** · 09-24-2015, 12:29 AM

It has become slower than the code you posted in Post #1?

I don't think my code is doing absolutely anything to slow down your macro really..

**meus** · 09-24-2015, 12:37 AM

No Actually i haven't used the code of post 1. Just wanted to be sure about that code...
I had used the code of post 3 which is just for pivot table 1. Because of my post 3 code, the macro was running slightly faster and i thought if i did the same for all four pivot table, it could be more faster. Hence, i posted the first post with my logic hoping someone could minimize the code or had any better ideas. Then i tried your code, it works fine but works slower than my third post code.. So i got confused...

Thanks

**NeedForExcel** · 09-24-2015, 01:11 AM

But your code in Post#3 is just manipulating 1 Pivot table, and mine is manipulating 4.. So obv it will be slower.. But I think its the rest of your code which might need optimization..

Apply Pivot Table Maual Update =True

LinkBack

Thread Tools

Rate This Thread

Display

Apply Pivot Table Maual Update =True

Re: Apply Pivot Table Maual Update =True

Re: Apply Pivot Table Maual Update =True

Re: Apply Pivot Table Maual Update =True

Re: Apply Pivot Table Maual Update =True

Re: Apply Pivot Table Maual Update =True

Thread Information

Users Browsing this Thread

Similar Threads

VBA Pivot Table Filter Set Filter to True if True Exists

How to apply multiple label filters on pivot table at once

Need to apply Form Controls or Active X Controls to Pivot Table

Automatically Apply Macro's/Formula's and Pivot Table attributes

Excel 2007 : How to apply 17.5% VAT to a certain row label on a pivot table?

Apply filter in a pivot table

[SOLVED] Apply a formula as a pivot table calc or suggestion

Bookmarks

Bookmarks

Posting Permissions