+ Reply to Thread
Results 1 to 4 of 4

i cannot filter the values from drop down list from a pivot table report

  1. #1
    Registered User
    Join Date
    08-19-2012
    Location
    Dhaka
    MS-Off Ver
    Excel 2003
    Posts
    7

    Question i cannot filter the values from drop down list from a pivot table report

    Hello All,

    I am a new member in this forum. I've got a problem in pivot table. here i attached a file for your understanding.
    In the attached file: orders followup sheet >> i cannot use the drop down list of column G,H,I to choose a specific date.

    when i try this my PC hangs. Can you help m e??????

    it is very urgent for me.
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: i cannot filter the values from drop down list from a pivot table report

    Hi Mamun,

    Welcome to the forum.

    I selected 3Sep2012 in last column of pivot and I saw two rows...
    See if you wish to select a specific date in all three column (G,H,I) then that date need to be present in all three columns.. hope you got it

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    08-19-2012
    Location
    Dhaka
    MS-Off Ver
    Excel 2003
    Posts
    7

    Question Re: i cannot filter the values from drop down list from a pivot table report

    Hello Dilip,

    thanks for your prompt reply. I got the point. But my problem is when i try to do this in my OFFICE 2003 format. I cannot use office 2007, because it is not allowed in my workplace.

    So, when i try to do the filter in 2003 excel, my laptop hangs. can you please check it again??

    thanks again.

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: i cannot filter the values from drop down list from a pivot table report

    HI Mamun,

    Pivots created in latest versions (xlsx) Excel 2007 or later does'nt work in full functional in Excl 2003 or earlier versions.. you can check microsoft site for more details on this. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1