Add PivotItems to PivotTable / Enabling - Disabling PivotItems
Hi there,
is there any way to change the visibility - state of PivotItems AT ONCE ? With an "Offline OLAP - Cube" this is possible. I'would like to know, if there's some funcionality for "PivotTables", too. I present some SAP - Data within this pivottable and want to give the users the possibility to change product groups. These groups control, what PivotItems are visible and what aren't. By now, i have to refresh row by row. So i fear my users will suffer of epilepsy, since the screen is flickering horrendously. With Olap cubes, i had to: ActiveSheet.PivotTables("PivotTable1").CubeFields( 1).TreeviewControl.Hidden = _ Array(new_items_helper, new_items_cube_list) and the update process went by as smooth as opening a blank word document! Is there a TreeViewControl for the PivotFields, too, that allows one to set the state of multiple PivotItems at once ? Greetings and excuse this bad english, Ole V.-M. |
Add PivotItems to PivotTable / Enabling - Disabling PivotItems
To the best of my knowledge, no. I can't say for xl2002 - perhaps something
was added. Regards, Tom Ogilvy "Ole" wrote in message om... Hi there, is there any way to change the visibility - state of PivotItems AT ONCE ? With an "Offline OLAP - Cube" this is possible. I'would like to know, if there's some funcionality for "PivotTables", too. I present some SAP - Data within this pivottable and want to give the users the possibility to change product groups. These groups control, what PivotItems are visible and what aren't. By now, i have to refresh row by row. So i fear my users will suffer of epilepsy, since the screen is flickering horrendously. With Olap cubes, i had to: ActiveSheet.PivotTables("PivotTable1").CubeFields( 1).TreeviewControl.Hidden = _ Array(new_items_helper, new_items_cube_list) and the update process went by as smooth as opening a blank word document! Is there a TreeViewControl for the PivotFields, too, that allows one to set the state of multiple PivotItems at once ? Greetings and excuse this bad english, Ole V.-M. |
All times are GMT +1. The time now is 09:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com