displaying pivot fields
Hi I have a pivot table, I have a pivot field with about 100 different
items in it. I want to create a macro that will hide the currently visible field item, and display the one selected in a dropdown. However, if I make the selected one visible and create a loop to go through all the field items and make the ones that dont match the selected on to invisible, it takes about 1 aminute to run as there are over 100 field items, and there are 9 pivot tables. is there a way to do the following... start a = currently visible pivot item b = new pivot item I want visible make b visible make a invisible end instead of looping through all the pivot field items. note that there is only ever one pivot filed item displaying at a time |
All times are GMT +1. The time now is 01:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com