+ Reply to Thread
Results 1 to 2 of 2

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
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Refresh All Button Not Refreshing Pivot Tables Excel 2016

    duplicate: https://www.excelforum.com/excel-cha...tml?highlight=
    Ben Van Johnson

+ 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. Refresh All Button Not Refreshing Pivot Tables Excel 2016
    By hkfenmil in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-10-2017, 03:35 AM
  2. Excel 2016 - Pivot table not refreshing
    By Cubicle Convict in forum Excel General
    Replies: 1
    Last Post: 05-31-2017, 10:11 AM
  3. [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
  4. [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
  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