Hi,
I'm currently working with a Legacy System whose only output is pivot
tables in Excel.
If I need certain data, I change the pivot table to get the information
I want. All the info is stored in the PivotCache as normally info would
exceed 65535 lines, so theres no detail in DB format.
I'd like to know if it's possible to connect Access to the pivotCache
of the Excel file, to gather information through queries.
Regards.
LC