ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I identify the OLAP datasource of a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/72870-how-do-i-identify-olap-datasource-pivot-table.html)

smisich

how do I identify the OLAP datasource of a pivot table
 
I have many pivot tables in a work book. How do I identify the OLAP
datasource of each pivot table without having to write it down somewhere.
Is there some VB code I could use?

Thanks


All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com