Don't Show Blank Pivot Table Fields in Drop-downs
Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Don't Show Blank Pivot Table Fields in Drop-downs

  1. May 6th, 2007 #1
    cs2007
    cs2007 is offline Senior Member
    Join Date
    3rd May 2007
    Posts
    191

    Don't Show Blank Pivot Table Fields in Drop-downs

    Hi all,
    I am creating a pivot table from region, which some of the rows are blank.
    Is there any possibility that the pivot table not show the blank in its dropdown combobox?

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  2. May 6th, 2007 #2
    Dave Hawley's Avatar
    Dave Hawley
    Dave Hawley is offline Administrator
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,624

    Re: Pivot Table

    tanha, POOR THREAD TITLE Please read THIS PAGE and THIS PAGE IN FULL

    I will edit it this time, but next time your post will be deleted.
    Reply With Quote Reply With Quote
  3. May 6th, 2007 #3
    cs2007
    cs2007 is offline Senior Member
    Join Date
    3rd May 2007
    Posts
    191

    Re: Pivot Table

    thanks for editing the TITLE...

    I found the Solution,
    I named the Region which was needed for pivot table, then the Blank word not appears in dropdown of pivot table field...

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  4. May 6th, 2007 #4
    ByTheCringe2
    ByTheCringe2 is offline OzMVP
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,899

    Re: Don't Show Blank Pivot Table Fields in Drop-downs

    tanha, Thanks for sharing your solution with us.

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  5. May 6th, 2007 #5
    cs2007
    cs2007 is offline Senior Member
    Join Date
    3rd May 2007
    Posts
    191

    Re: Don't Show Blank Pivot Table Fields in Drop-downs

    Thanks too.
    Actually I found the solution from this forum, unfortunatly I forgot the correct link, so I put the file I downloaded from here...all Rights and Thanks are for the one who made this
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
« Finding Last Used Column | Print Multipage Userform »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Pivot Table Macro To Only Show Fields As Per Cell Values
    By TimX81 in forum EXCEL HELP
    Replies: 1
    Last Post: July 2nd, 2008, 10:12
  2. Reset All Pivot Table Fields To Show All
    By oediaz in forum EXCEL HELP
    Replies: 1
    Last Post: December 21st, 2007, 09:02
  3. Hide/Show Pivot Table Fields
    By DannyBoy in forum EXCEL HELP
    Replies: 5
    Last Post: October 11th, 2007, 20:28
  4. Pivot table row and column field drop downs
    By Batman in forum EXCEL HELP
    Replies: 2
    Last Post: July 7th, 2005, 17:32
  5. Pivot Tables: Displaying Text in Pivot Table Data fields
    By sergv in forum EXCEL HELP
    Replies: 1
    Last Post: September 18th, 2003, 00:13

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules