+ 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
    Excel 2010
    Posts
    4

    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 2010/2019
    Posts
    7,684

    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)

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