Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Efficient Source Range
Hello,
I have 10 pivot tables that keying off the same range that has 63 columns and about 10,000 - 15,000 rows (fluctuates daily). What is more efficient for the source range in terms of recalculation (refreshing pivots): having dynamic named range or using some safe range like $A$1:$BK$16000? Thank you, -- ______ Regards, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using cursor keys to select Pivot Table Source Data Range | Excel Discussion (Misc queries) | |||
Pivot Table Source Worksheet and Range | Excel Discussion (Misc queries) | |||
Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
Transforming pivot table back to the source table | Excel Worksheet Functions |