PC Review


Reply
Thread Tools Rate Thread

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


 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:18 PM.