jmenche
01-30-2013, 12:46 PM
Howdy,
I have a sheet with a few pivottables on it. I have some drop downs up top that allow the user to select two different products and a macro loops through and updates the 'Product' field in each pivot with the user selection.
Here's the issue. What the macro does is make the two new products visible and then hides the two old products. Since you cannot have all items hidden at once, all four items are visible at one point. This causes the pivot rows to expand and contract because the row selections can be different for each product. When the pivot rows expand, it encroaches on the pivottable below it and I get an error. I don't want to leave all kinds of rows blank between them because it looks stupid.
Is there a way to change the products without the pivot updating like that in the interim?
Thanks
Jeff
:beerchug:
I have a sheet with a few pivottables on it. I have some drop downs up top that allow the user to select two different products and a macro loops through and updates the 'Product' field in each pivot with the user selection.
Here's the issue. What the macro does is make the two new products visible and then hides the two old products. Since you cannot have all items hidden at once, all four items are visible at one point. This causes the pivot rows to expand and contract because the row selections can be different for each product. When the pivot rows expand, it encroaches on the pivottable below it and I get an error. I don't want to leave all kinds of rows blank between them because it looks stupid.
Is there a way to change the products without the pivot updating like that in the interim?
Thanks
Jeff
:beerchug: