Arrays as source data for Pivot Table Caches

  • Thread starter Thread starter midori
  • Start date Start date
M

midori

Hi,

All the documentation I've seen for pivot table caches assume either a
worksheet range or an OLE DB connection as the source data. Is it
possible to set a 2D array as the source data?

Cheers,
Shu
 
hi, !
All the documentation I've seen for pivot table caches
assume either a worksheet range or an OLE DB connection as the source data.
Is it possible to set a 2D array as the source data?
Click to expand...

FWIW you could "write-down" the array (to cells) and then "load-up" (from range) -?-

hth,
hector.
 
Back
Top