Add PivotItems to PivotTable / Enabling - Disabling PivotItems

O

Ole

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.
 
T

Tom Ogilvy

To the best of my knowledge, no. I can't say for xl2002 - perhaps something
was added.

Regards,
Tom Ogilvy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top