View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg Greg is offline
external usenet poster
 
Posts: 331
Default 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