CODEWITHSUNDEEP
excelanalyticspivot-tablevba
user1573375
user1573375

Reputation: 1

Displaying a list of pivot tables with their parameters

I have a workbook with many worksheets with many pivot tables. Having an overview in one place of all these pivot tables would be great to ensure I have consistent parameters, titles, etc.

It should display key info such as:

Worksheet name, Pivot Table Name, Pivot Table location, Hyperlink to location, chose parameters (such as OLAP support, current connected slicers, etc., Type (power pivot or standard)

I guess we would all be happy to have this for all our complex applications. Would anyone have a clue on how to design this in VBA or something else?

Upvotes: 0

Views: 3207

Answers (1)

Sam
Sam

Reputation: 7303

You should be able to loop through pivot tables and grab information with something like:

Dim pvt As PivotTable
Dim ws As Worksheet
Set ws = ThisWorkBook.ActiveSheet
For Each pvt In ws.PivotTables

'collect data about pivot tables and output somewhere..
Next pvt

if the pivot tables are in multiple worksheets then nest that loop inside a loop that cycles through the workbooks worksheets.

Does that provide an adequate starting point for you?

Upvotes: 1

Related Questions