Arrays as source data for Pivot Table Caches

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
 
H

Héctor Miguel

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.
 
Top