PivotTable cache (XL 2003)

Topic

New Reply

Hi All – I have a ‘friend’ who has been given 2 xl files, each containing one pivot table based on sales data for a company for one year (2005 & 2006 respectively). The goal is to compare the data for the two years. However, the data exists in the file in the embedded cache only. We don’t have access to it anymore. But we would like to extract it to a whole data table.

I can only find solutions that use the GetPivotData feature. But that only gets one item at a time, as far as I can tell.

There MUST be a way to export the entire data cache from the files, wouldn’t you think?

Anyone have some ideas?

Thanks,

Rich P

Reply | Quote

Replies

Have you tried removing all row, column and page fields from the tables, then double-clicking on the data total field that remains?

Reply | Quote

Can you send me a picture of you so I can set up a shrine to worship you! Man – You are good.

The answer is – No – I didn’t do that. It never ocurred to me. But it worked perfectly!

This is a clear case of looking for a complicated solution when a double-click will do!

Thank you so much!!!

Best Regards…

Rich P

Reply | Quote

Here you go: me looking a bit rough after a heavy night

Reply | Quote