Disable 'Select Multiple Items' and '(All)' in PivotTable ReportFilter

JRF

Guest

Posts: n/a

17th Jul 2009

I would like to disable the 'Select Multiple Items' and '(All)'
features from a PivotTable Report Filter (Page items). I do not
know
how to do it.

I have data for multiple years that I would like to be able to see
using the filter, but it makes no sense to add data together from
different years. Therefore, I do not want a user to pick All or to
Select more than one year.

Can anyone help?

Regards

John

« Addobe PDF printer | Create Object MS MapPoint »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing multiple PivotTable filter items based on a cell value	C4RL	Microsoft Excel Programming	0	15th Jun 2010 10:44 AM
Disable "Select Multiple Items" in Pivot Table	=?Utf-8?B?UGFzaGE=?=	Microsoft Excel Programming	0	13th Oct 2005 12:45 AM
Is there anyone knows PivotTable about "Select multiple items"(Urg	=?Utf-8?B?TWljcm9sb25n?=	Microsoft Excel Programming	2	2nd Mar 2005 02:03 AM
disable select multiple items in pivot table	belinda	Microsoft Excel Misc	0	24th Jun 2004 08:57 AM
PivotTable help: I want a checklist for multiple items	Michael	Microsoft Excel Worksheet Functions	2	11th Apr 2004 01:29 PM