+ Reply to Thread
Results 1 to 2 of 2

Help with pivot table not refreshing.

  1. #1
    Registered User
    Join Date
    11-13-2011
    Location
    England
    MS-Off Ver
    Office 2019
    Posts
    33

    Help with pivot table not refreshing.

    Hi I hope i can make this as clear as possible. I have 3 tables in a work sheet all of which have data that relates to various cycles throughout the year. I have created connections between table 1 and table 2 using a merge query and the joining field is “Subject”. I have made a connection between table 2 and 3 using another merge and have linked this using A field called “Cycle ID” I have then made a connection between table 1 and 3 using another merge using “Cycle”as the linked field. I then create Merge Query and output to a worksheet and called this “Mergefinal”

    Now when i look at all the queries the data is as it should be and changes according to the cycle i select. However when creating various pivot tables using “Mergefinal” as the source the only pivot table that will not refresh is the one that contains data connected to the cycles. In other words if i use a slicer and choose either of the cycles, every other pivot table refreshes except one. So “cycle 1” and “cycle 2” should be a different value for “subject A”.

    I hope this makes sense.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Help with pivot table not refreshing.

    It may help if you upload a desensitized sample of the workbook that is displaying the behavior described in post #1.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] pivot table not refreshing new data
    By dougers1 in forum Excel General
    Replies: 3
    Last Post: 12-18-2018, 04:33 PM
  2. Pivot Table not refreshing - HELP
    By milo1984 in forum Excel General
    Replies: 0
    Last Post: 09-12-2018, 07:03 AM
  3. [SOLVED] Pivot Table Data Not Refreshing from Named Table
    By Seth_ in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-04-2016, 11:10 AM
  4. Pivot table not refreshing
    By Zealotwraith in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-18-2013, 12:02 PM
  5. Refreshing Pivot Table
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2009, 04:59 PM
  6. [SOLVED] VC Problem refreshing pivot table
    By Vickster3659 in forum Excel General
    Replies: 6
    Last Post: 06-01-2005, 11:05 AM
  7. Refreshing a pivot table
    By Louise in forum Excel General
    Replies: 2
    Last Post: 05-23-2005, 09:06 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