PivotTable PivotCache database export in VBA?

[zeee1980]

Good morning.

Is it possible, PivotCache datas export to CSV with macro?
Its excel file is offline so I would like to export the original datas what is in PivotCache (not the SourceData and not the PivotTable).

Please help me.
I am waiting for your response.
Thank you in advance.
Best regards.

[BellyGas]

Turn on the macro recorder, double click your pivot table to view the base data in the cache, click saveas and select active sheet only, save as csv.

Job done.

[zeee1980]

Thank you, it is working.

But its important for everybody, if we want the complete data that need to switch off all filter of PivotTable.