R
robert2b
i have a pivot table with over a million rows. the connection to the original
external source can be assumed to inaccessible. however, the contents of the
data underneath the pivot table (PivotCache?) will not change.
i need to perform thousands of analysis operations can be derived from
tables "filtered out of" the underlying PivotCache. for example, the simplest
operation would be to divide the contents of one of the tables derivable from
the cache by the contents of another table derivable from the cache, element
by element. the more complex operations would involve algebraic operations
across multiple tables on a corresponding table element-by-element basis.
i am aware that i can pull "tables" from the PivotCache in VBA and dump the
result into worksheet ranges. can i dump the "tables" directly into a VBA
array instead so that i can do the aformentioned processing? if yes, any
simple example that shows how to load the contents of a "table" into a VBA
array would be very valuable.
i did look for pre-existing responses to my question and have not found any.
i do apologize if this has been addressed and i missed it.
many thanks..
external source can be assumed to inaccessible. however, the contents of the
data underneath the pivot table (PivotCache?) will not change.
i need to perform thousands of analysis operations can be derived from
tables "filtered out of" the underlying PivotCache. for example, the simplest
operation would be to divide the contents of one of the tables derivable from
the cache by the contents of another table derivable from the cache, element
by element. the more complex operations would involve algebraic operations
across multiple tables on a corresponding table element-by-element basis.
i am aware that i can pull "tables" from the PivotCache in VBA and dump the
result into worksheet ranges. can i dump the "tables" directly into a VBA
array instead so that i can do the aformentioned processing? if yes, any
simple example that shows how to load the contents of a "table" into a VBA
array would be very valuable.
i did look for pre-existing responses to my question and have not found any.
i do apologize if this has been addressed and i missed it.
many thanks..