+ Reply to Thread
Results 1 to 3 of 3

Refresh All Button Not Refreshing Pivot Tables Excel 2016

  1. #1
    Registered User
    Join Date
    07-07-2017
    Location
    Texas, U.S.
    MS-Off Ver
    Windows 7
    Posts
    4

    Refresh All Button Not Refreshing Pivot Tables Excel 2016

    I have a workbook with multiple Power Queries, some of which directly feed into Pivot Tables. When entering new data and clicking the Refresh All button under the Data tab, all of the corresponding queries (queries that pull in the new data from whichever query table is updated) are updated, but none of the Pivot Tables that reference data from the Power Query tables are updated. The only way I have found to refresh the Pivot Table is to click on the Pivot Table and click on the Refresh button under the PivotTable Tools Analyze tab.

    I know that the Refresh All button under the Data tab is supposed to refresh everything, including Pivot Tables, so why is it not working for me?

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

    Re: Refresh All Button Not Refreshing Pivot Tables Excel 2016

    Try click Refresh All twice
    or
    look for VB to refresh PQ first then PT
    or you can use:
    (right click on TAB and View Code)
    Please Login or Register  to view this content.
    where Pivot Table is a name of sheet where PT is, and Pivot Table1 is a name of PT
    Last edited by sandy666; 07-07-2017 at 07:51 PM.

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Refresh All Button Not Refreshing Pivot Tables Excel 2016

    Hi,

    You might also go through the properties of each connection listed (Data tab, then Connections) and uncheck the 'Enable background query' option.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Excel 2016 - Pivot table not refreshing
    By Cubicle Convict in forum Excel General
    Replies: 1
    Last Post: 05-31-2017, 10:11 AM
  2. [SOLVED] Auto Refresh Pivot Tables Excel 2016 for Mac
    By sbothe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2017, 01:23 PM
  3. [SOLVED] macro button to update filters and refresh pivot tables in other sheets
    By seanpcorbett1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2016, 03:48 PM
  4. Pivot tables not refreshing through VBA - Possibly an Excel Bug?
    By somolov in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2014, 03:24 PM
  5. Replies: 5
    Last Post: 05-20-2014, 11:24 AM
  6. Button to Refresh to All Pivot Tables
    By manny_cb in forum Excel General
    Replies: 3
    Last Post: 07-18-2008, 01:32 PM
  7. [SOLVED] Refreshing MS Query and Excel Pivot Tables using VBA
    By hoppermr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2005, 07:10 PM

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