Hello!
I have a huge number of pivot reports in excel that are very complicated.
For each of them the running time is very long (3-4 minutes).
Part of that time is designing of the pivots.
May anyboby to edvice me if i can to build pivot templates with design ahead.
Thanks in advance,
Marina.

You can always build the pivots with some source data, then change the
source. You would need to be careful that the data used to build the tables
and the eventual data you will use are similar in terms of values or you
could get a lot of "ghost" values. Say you had the field Letter and the
eventual data would only have choice of C, D and E. If you built the table
with source data that had choices of A, B, C, then when you changed the
source the choices (items) would be A, B, C, D, E even though the source
data had no A or B data records.

--
Regards,
Tom Ogilvy

"Marianna" wrote in message
m...
Hello!
I have a huge number of pivot reports in excel that are very complicated.
For each of them the running time is very long (3-4 minutes).
Part of that time is designing of the pivots.
May anyboby to edvice me if i can to build pivot templates with design
ahead.
Thanks in advance,
Marina.