Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Coding PivotTables based on OLAP data
PivotTables based on OLAP cubes don't use standard pivot table objects (i.e. .pivotfields().pivotfields().visible). I have been unsuccessful in finding any decent documentation. When you record a macro it uses .treeviewcontrol.hidden and .treeviewcontrol.drilled - help says these objects are...- jmtruji2
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
