Pivot Table Page Field Area Broken

We have a Pivot Table I put together over a year ago, which links to an MS Access database.
It is used by a number of people, and recently its been behaving a little strangely.

I actively encourage the users of pivot tables to try to 'break' pivot tables, to encourage them to edxperiment with them and to use them to their full potential.

WELL...it turns out someone may have actually managed to break one of my pivot tables.

It appears the when a field item is dropped into the page field area, it no longer allows the user to customise the items in the list (multiple items).
It allows the user to carry out the actions to configure the list: Field Settings>Hide selected Items> and these actually disappear from the list, but the page field item still states (All) and the total value does not change when the items are filtered.

I was hoping someone may have had experience with the same problem, as I am really trying to find out what the cause is rather than how to fix it (I'll rebuild).

Any thoughts or comments would be much appreciated
Kind Regards
GarethG

Gareth,
If you move the offending field into the row area or column area of the
pivot table, you can change which items are selected (presumably changing it
back to all items). Then you can drag the field back into the Page field area
and all items should be available to you.

Hope this helps! It's a late reply, but maybe it'll still be useful.
Julia


"GarethG" wrote:

>
> We have a Pivot Table I put together over a year ago, which links to an
> MS Access database.
> It is used by a number of people, and recently its been behaving a
> little strangely.
>
> I actively encourage the users of pivot tables to try to 'break' pivot
> tables, to encourage them to edxperiment with them and to use them to
> their full potential.
>
> WELL...it turns out someone may have actually managed to break one of
> my pivot tables.
>
> It appears the when a field item is dropped into the page field area,
> it no longer allows the user to customise the items in the list
> (multiple items).
> It allows the user to carry out the actions to configure the list:
> Field Settings>Hide selected Items> and these actually disappear from
> the list, but the page field item still states (All) and the total
> value does not change when the items are filtered.
>
> I was hoping someone may have had experience with the same problem, as
> I am really trying to find out what the cause is rather than how to fix
> it (I'll rebuild).
>
> Any thoughts or comments would be much appreciated
> Kind Regards
> GarethG
>
>
> --
> GarethG
> ------------------------------------------------------------------------
> GarethG's Profile: http://www.excelforum.com/member.php...info&userid=82
> View this thread: http://www.excelforum.com/showthread...hreadid=394162
>
>