I am wondering if i need to do this and if its possible-
My spreadsheet app has about 20 tables referencing 4 caches of data...
I read something John Walkenbach wrote that said to minimize the number of caches by copy/pasting pivot tables rather than creating a fresh pivot table.
I was trying to do that, but when I check activeworkbook.pivotcaches I see I have 3 caches for 1 of my data sources- which are fairly small- outside estimate of 1000 records with 5 columns.
how much should I care about this? ... can I change all to reference the same cache and delete without redoing the pivot tables...is it worth redoing pivot tables if not?
adjusting filters on pivot tables doesnt establish new caches does it? I figure I must have accidentally created them somehow. not entirely sure how/when.
using win 2007
My spreadsheet app has about 20 tables referencing 4 caches of data...
I read something John Walkenbach wrote that said to minimize the number of caches by copy/pasting pivot tables rather than creating a fresh pivot table.
I was trying to do that, but when I check activeworkbook.pivotcaches I see I have 3 caches for 1 of my data sources- which are fairly small- outside estimate of 1000 records with 5 columns.
how much should I care about this? ... can I change all to reference the same cache and delete without redoing the pivot tables...is it worth redoing pivot tables if not?
adjusting filters on pivot tables doesnt establish new caches does it? I figure I must have accidentally created them somehow. not entirely sure how/when.
using win 2007
