• Clearing Pivot Table filters

    Author
    Topic
    #464885

    Hi

    I am using Excel 2003 and creating pivots, does anybody know a way of cleaning the Pivot Field filter dropdowns.

    I have a field which had some bad data loaded, when you look at the dropdown filter is showed the correct data and the wrong data, having cleaned up the source data the dropdowns still showed the rubbish data and I have never been able to get rid of it, unless I rebuild the pivot again.

    Anyway of reseting these dropdowns

    Regards

    Mike

    Viewing 0 reply threads
    Author
    Replies
    Viewing 0 reply threads
    Reply To: Clearing Pivot Table filters

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: