+ Reply to Thread
Results 1 to 3 of 3

Accidently entered value in a Row Label cell - now I can't update real values from source

  1. #1
    Registered User
    Join Date
    09-14-2004
    Location
    Jämtland, Sweden
    Posts
    16

    Accidently entered value in a Row Label cell - now I can't update real values from source

    Excel 2010 (Office Pro Plus 2010):

    If I create a PivotTable and enter a value manually in a Row Label cell, then I can't make the table refresh its data to reflect the source data again. All values in the Value fields stick with the original Row Labels, but the actual value in the Row Labels shows the manually entered value and not the source value.

    It doesn't help to change "Number of items to retain per field" to "None" in the PivotTable options and then refresh.
    It doesn't help to uncheck "Save source data with file.

    I don't want to make a new Pivot, I want to know if it's possible to make the Pivot refresh properly and ignore manual entries that have been done.

    See attachment.

    Any ideas?
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Accidently entered value in a Row Label cell - now I can't update real values from sou

    If you remove field Label2, refresh table and then apply field Label2 it will reset.

    Or you could use a line of code in the immediate window of the VBE

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-14-2004
    Location
    Jämtland, Sweden
    Posts
    16

    Re: Accidently entered value in a Row Label cell - now I can't update real values from sou

    Both methods worked in my sample file - thanks! However, none of the methods worked in my real file that I'm working on.
    BUT - I solved it by grouping the problematic field and ungrouping it again! Wierd, but it worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Real Time CELL UPDATE
    By excelV3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2014, 03:00 PM
  2. Need vba code Real Time Update from 2 workbooks through so's get values of column
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2013, 06:15 AM
  3. user form label real time update
    By samz93 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2013, 11:38 AM
  4. Real time update of Userform label with cell value
    By KyleLee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2009, 09:58 AM
  5. Replies: 2
    Last Post: 07-08-2008, 07:15 AM

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