+ Reply to Thread
Results 1 to 7 of 7

why won't pivot table update with new rows added to data table even after pressing refresh

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    58

    why won't pivot table update with new rows added to data table even after pressing refresh

    hi everyone,

    just wondering if anybody has had this dilemma before?

    sorry if this question has the possibility to be vague.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: why won't pivot table update with new rows added to data table even after pressing ref

    Does the range include the new rows?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: why won't pivot table update with new rows added to data table even after pressing ref

    i believe so. here is my sample worksheet. the data table that i am using is placed under cashflow. sheet 4 is the worksheet of my pivot table

  4. #4
    Registered User
    Join Date
    10-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: why won't pivot table update with new rows added to data table even after pressing ref

    here is the file
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: why won't pivot table update with new rows added to data table even after pressing ref

    i also have some odd feeling it has something to do with my source data

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: why won't pivot table update with new rows added to data table even after pressing ref

    Your range is not extending for the new data. I added a big amount for rental in 3/1/13 in E66 (5 000000), it did not update. But when I extended your range to row 70, it did (after refreshing.

    Also, you probably know you have a circular reference error on Cachflow sheet?

  7. #7
    Registered User
    Join Date
    01-18-2014
    Location
    calif usa
    MS-Off Ver
    excel 2013
    Posts
    9

    Re: why won't pivot table update with new rows added to data table even after pressing ref

    YES happens to me. I have to exit program. then re-enter. Also have workbooks open that transfer data. They also have to be closed.?

+ 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. Replies: 3
    Last Post: 03-28-2014, 12:04 PM
  2. Macro to refresh pivot table and update data source
    By TBO in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2013, 01:09 PM
  3. Replies: 1
    Last Post: 03-02-2010, 10:40 PM
  4. Replies: 2
    Last Post: 11-03-2009, 03:30 PM
  5. Replies: 5
    Last Post: 11-24-2005, 11: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