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 SettingsHide 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

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 SettingsHide 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