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 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 :eek: -- 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 :eek: -- GarethG ------------------------------------------------------------------------ GarethG's Profile: http://www.excelforum.com/member.php...info&userid=82 View this thread: http://www.excelforum.com/showthread...hreadid=394162 |
All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com