+ Reply to Thread
Results 1 to 5 of 5

Updating Tables From Pivots

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2003
    Posts
    2

    Updating Tables From Pivots

    Hello, I've been trying to work this out on my own for awhile now but I've hit a bit of a wall. I'm trying to get a table generated froma pivot table to update if the pivot is refresh and if data changes on that pivot. The first image shows three items owned by three different people. The first set is what was entered by myself, the second is the pivot generated by that set, the thrid is generated when I double click the grand total value.

    Capture.PNG

    Below I have updated the raw data and the pivot but I see no way to update the table that was created from the pivot. In my mind it stopping at the pivot does not really make ans sense to me. Am I missing something?

    Capture2.PNG

    I am using Excel 2016
    Attached Files Attached Files
    Last edited by WinterTT; 12-07-2017 at 05:49 PM. Reason: Example file added

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Updating Tables From Pivots

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
    Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

    To attach an Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

  3. #3
    Registered User
    Join Date
    11-06-2012
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Updating Tables From Pivots

    Thank you for the information. I have attached an example file as you recommended.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Updating Tables From Pivots

    The extracted records are copies of the original records in the pivot table source data. They are not linked to the original records or to the pivot table. If you want to change the data, go to the original source data, and make the change there.

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Updating Tables From Pivots

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

+ 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. [SOLVED] Updating Pivots every time a macro executes
    By liquidmettle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2016, 12:56 AM
  2. VBA updating multiple pivots issue
    By imatomic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2015, 01:08 PM
  3. Excel Pivots for split tables
    By Jabali in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2014, 02:33 AM
  4. Replies: 0
    Last Post: 08-23-2011, 10:00 AM
  5. Excel 2007 : Two pivots tables acting the same
    By mcmuney in forum Excel General
    Replies: 3
    Last Post: 11-30-2010, 03:35 AM
  6. Refreshing a variety of Pivots tables
    By Lorna B in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-06-2009, 11:06 AM
  7. Updating all pivots when opening workbook
    By JoFo in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-23-2008, 11:26 AM

Tags for this Thread

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