1

Topic: To accelerate pivot table formation

Hello!
There is a macro which forms the big difficult pivot table. If in a source code it is a lot of lines the pivot table is long formed. In the code there are three units, where . It is More  in the third unit where paints over cells on the pivot table. In comments specified where these units are.
The macro not small, but tried to write clearly and removed superfluous that it was possible to disassemble. In the initial data of digit conditional.
It is necessary to consider that global constants and variables are registered in the separate unit. As in the work file it is a lot of units, it is a lot of macroes and macroes fulfill a difficult functional.
Do not pay attention that the code in Russian.
Formation time - 20 minutes.
How it is possible to accelerate formation of the pivot table for each unit?
Excel th file with a macro

2

Re: To accelerate pivot table formation

ferzmikk wrote:

formation Time - 20 minutes.

the code I truth did not look yet, but I doubt the approach
--At you 40 lines, in summary 300
--And it on the conditional example, where on 3 fields number of different values more than 100 (from 300 to 3000)
--On remaining 18 fields from 10 to 100 different values
--On the real table I think that it is more than values
--Filters of 63 combinations
Certainly in  to work with such tables is easier
--I would highlight 1st screen of 63 lines (taking into account remaining 18 filters)
--At a clique on these 18 cells (fields) - would highlight  this position
Nobody can work with 300-1000 lines, besides update the slowest

3

Re: To accelerate pivot table formation

wrote:

- at you 40 lines, in summary 300

in summary row with the out-of-operation filter the last line is 40501.

4

Re: To accelerate pivot table formation

wrote:

it is finite in  to work with such tables easier
--I would highlight 1st screen of 63 lines (taking into account remaining 18 filters)
--At a clique on these 18 cells (fields) - would highlight  this position

It is the pivot table already adjusted. The necessary order of fields with hierarchy. It is possible to look on one element from a field "Pole2".