Topic: To accelerate pivot table formation
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