When I go to the actual pivot table it runs fast when I sort and pick manually, but for some reason this code runs very slow in this macro?

HTML Code: 

I actually have this do this true or false if a certain pulldown is selected...so I have about 33 of these statements (depending upon which item is selected)

Like I said before, if I select all or refresh..the table updates very quickly.

There must be something different about how the 2 work????