Pivot Tables Rows

[hans]

Im using several Pivot Tables that are linked to the
database of our accounting system. The Pivot Tables show,
per row, account numbers and their balance. We have a
great number of account numbers, but in each Pivot Table I
have only selected (ticked) a few.

The problem I have is that when new account numbers are
added in the system, they automatically show up (after
refresh) in the Pivot Tables. They are ticked by default
and I have to go through all Pivot Tables and manually
deselect them.

Is there a way to go around this? I only want the Pivot
Tables to show the account numbers I have selected and not
anything else.

regards,
Hans

 

[Paul Falla]

Dear Hans
As far as I am aware, Excel will always add the new
account numbers to your pivot table due to the way it is
programmed. A way around this is to highlight the account
numbers, then right mouse click,Select Group and Outline,
then select Group. You will see that Excel has added an
extra field alongside your account numbers and called it
something along the lines of Account numbers(2). Give this
group a meaningful name by typing it into the first cell
in the group, and then drag the field into the page field
section. You can then select just the grouped field name
from the drop down list.

I hope this helps

Paul Falla

 

[Hans]

Hello Paul

Many thanks for your help. Its not really a nice and clean
solution to my problem, but I think this is probably the
only way to do it without a macro.

regards,
Hans