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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reference is not valid message for pivot tables based on Access query 4
Pivot Table - click through extract data formatting issue 1
Upadte PivotTable Data range 2
pivot table loosing decimals (vba) 1
Pivot Table Data Source, point to cell? 1
making an excel table visible for external data on pivot table 1
Excel Error while updating an external data source into a pivot table! 0
Pivot Table Not Behaving as Expected 1

Top