+ Reply to Thread
Results 1 to 3 of 3

2016 Power Queries do not refresh in Excel 365 Pro Plus

  1. #1
    Registered User
    Join Date
    01-20-2020
    Location
    Connecticut
    MS-Off Ver
    Excel 2016
    Posts
    1

    Exclamation 2016 Power Queries do not refresh in Excel 365 Pro Plus

    I used Excel 2016 to write a set of 18 Power Queries. The queries refresh perfectly fine. However, these same queries do do not refresh on a laptop with Excel 365 Pro Plus. The Excel crashes with "Not Responding" error message. Please help.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: 2016 Power Queries do not refresh in Excel 365 Pro Plus

    Welcome to the forum.

    We don't have an appropriate section for PQ questions, but as the VBA section certainly isn't appropriate, I've moved this to the general section for greater visibility.

    Are the 18 queries all in one workbook? How are they being run? On opening of the book? On manual refresh?

    Are you running them over a WiFi network or wired network? Is the laptop low-spec?

    There are so many possible factors here, but I cannot see that it will be the change of Excel version that will be the issue.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: 2016 Power Queries do not refresh in Excel 365 Pro Plus

    Fault find methodically, on the PC with the problem.

    Refresh each query in turn, until you find the one which is causing the problem. Once you've isolated the problem query, try stepping through in the query editor, to see if it's one step in particular causing the problem. If it works okay in the query editor, but not when you try refreshing the data model, then it may be related to volume, or to data below the first 1000 rows...

    If you're still stuck after this, post the offending query code, with as much information as possible detailing what you've investigated.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. Subtotal in Power Query Excel 2016
    By metsmaniac in forum Excel General
    Replies: 3
    Last Post: 08-06-2019, 04:07 AM
  2. Power Pivot not updating. Excel 2016
    By SueBristow in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-04-2019, 05:22 AM
  3. Excel 2016 - Power querry hep!!!!
    By sandeep2872003 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-01-2019, 07:30 AM
  4. Power Query - How to refresh queries?
    By ypurcaro in forum Excel General
    Replies: 11
    Last Post: 02-11-2019, 06:47 PM
  5. Appending Charts using Power Query Excel 2016
    By STokhi1 in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 07-02-2018, 07:30 AM
  6. Does My VBA Code To Refresh CSV Power Query Connections Need To Change for MySQL Queries?
    By beaglesBuddy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2017, 02:57 PM
  7. Excel VBA Script Crashes When Refreshing Power Queries Using Task Scheduler
    By beaglesBuddy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2017, 01:03 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