+ Reply to Thread
Results 1 to 4 of 4

Refresh Pivot Table Data Not Working Correctly

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    466

    Question Refresh Pivot Table Data Not Working Correctly

    Hi,


    Can any please advise me how I can Refresh Pivot Table Data as it appears not to be working correctly !!

    Basically, I delete data from my source data fields and then ! Refresh Data in the Pivot table the old (removed/delete/over written data) is still displayed in the drop down.

    Please see attached BMP file as an example e.g. I have /over written the names Alan. Dave, Nick & Pete from Colum E bit their names still appear in the pivot drop down list.

    Any assistance would be greatly appreciated

    Excel version 2003


    Many thanks


    Rob
    Attached Images Attached Images
    Rob

  2. #2
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255
    I think, if you remove the field from the pivot table, refresh, then put the field back, your name list will be correct.

  3. #3
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    And there is also a VBA solution at the following link :http://www.contextures.com/xlPivot04.html
    HTH

  4. #4
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    466

    All sorted - Many thanks

    Gary / Arthur many thanks for your assistance it is very much appreciated for your rapid reponses.

    Thanks again

    Rob

+ 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