How to design excel pivot

  • Thread starter Thread starter Marianna
  • Start date Start date
M

Marianna

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Corrupt files due to pivot remnants after saving via VBA 0
How to assign a macro to a pivot in Excel 2000 1
Using VBA on Excel Pivot Tables 3
How to build / refresh pivot table without ODBC?? 1
MS Excel VBA Pivot table link cell fetch records 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Automate Pivot Table with varing number of records 1
Pivot table drill down sort 0

Back
Top