software

Hello All,

Thanks for taking the time to look at this.

General
I have 5 SQL Tables with lots of data (about 15 columns in each table)
gt;From each of these 5 Tables I have about 6 Pivot tables. (30 Pivots
totat)
Each of the pivot tables have some custom calculations
Not all of the columns are used in each of the pivots.
Once the Pivots are refreshed a snapshot is taken of the sheets.
(Users do not interact with the pivots, so once refreshed they are
static)

Goal
Reduce the size of the spreadsheet and make refreshing it faster.

Question

1) Is it better to build each pivot table pulling back only the columns
I need for it, or is it better to have one Master Pivot Table (All
columns) and then build the 6 Pivots from it?

Any suggestions would be great!

Thanks

DougMy impression is that it's better to have one master and build all pivots
from that.

quot; wrote:

gt; Hello All,
gt;
gt; Thanks for taking the time to look at this.
gt;
gt; General
gt; I have 5 SQL Tables with lots of data (about 15 columns in each table)
gt; gt;From each of these 5 Tables I have about 6 Pivot tables. (30 Pivots
gt; totat)
gt; Each of the pivot tables have some custom calculations
gt; Not all of the columns are used in each of the pivots.
gt; Once the Pivots are refreshed a snapshot is taken of the sheets.
gt; (Users do not interact with the pivots, so once refreshed they are
gt; static)
gt;
gt; Goal
gt; Reduce the size of the spreadsheet and make refreshing it faster.
gt;
gt; Question
gt;
gt; 1) Is it better to build each pivot table pulling back only the columns
gt; I need for it, or is it better to have one Master Pivot Table (All
gt; columns) and then build the 6 Pivots from it?
gt;
gt; Any suggestions would be great!
gt;
gt; Thanks
gt;
gt; Doug
gt;
gt;