+ Reply to Thread
Results 1 to 7 of 7

Power Query dont update

  1. 10-23-2020, 01:29 AM #1
    Tonyhansson
    Tonyhansson is offline
    Registered User
    Join Date
    08-04-2020
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    56

    Power Query dont update

    Hi


    I have an Excel sheet with 2 power Querys, both are set up to refresh on start up.

    When I open, only 1 Query refresh. (Manual both refresh with no problem)


    How can I force Excel to refresh all, on start up?


    Regards


    Tony
    Reply With QuoteRegister To Reply
  2. 10-23-2020, 03:09 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,941

    Re: Power Query dont update 

    Please Login or Register  to view this content.
    or

    Clcik on Queries and Connections

    Select Properties and then check the box highlighted in the picture
    Attached Images Attached Images
    Last edited by alansidman; 10-23-2020 at 03:20 AM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 10-23-2020, 03:10 AM #3
    AliGW
    AliGW is offline
    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. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,431

    Re: Power Query dont update

    Set the query properties to refresh on file open.
    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.
    Reply With QuoteRegister To Reply
  4. 10-23-2020, 09:01 AM #4
    Tonyhansson
    Tonyhansson is offline
    Registered User
    Join Date
    08-04-2020
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    56
    Quote Originally Posted by AliGW View Post
    Set the query properties to refresh on file open.
    This is already done
    Reply With QuoteRegister To Reply
  5. 10-23-2020, 09:04 AM #5
    Tonyhansson
    Tonyhansson is offline
    Registered User
    Join Date
    08-04-2020
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    56
    Quote Originally Posted by alansidman View Post 
    Please Login or Register  to view this content.
    or

    Clcik on Queries and Connections

    Select Properties and then check the box highlighted in the picture

    I will try to use vba
    Reply With QuoteRegister To Reply
  6. 10-25-2020, 04:03 AM #6
    Tonyhansson
    Tonyhansson is offline
    Registered User
    Join Date
    08-04-2020
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    56

    Re: Power Query dont update

    Hi

    This is still not working.

    1st. Time I open workbook only 1 query is refreshed, if I open and close, 2nd time both query are refeshed.


    I have also made a import from access using a vba code forcing to open and refresh the workbook, but
    Still only one query is updated


    Did anyone try anything like this?


    Regards

    Tony
    Reply With QuoteRegister To Reply
  7. 10-25-2020, 04:05 AM #7
    AliGW
    AliGW is offline
    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. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,431

    Re: Power Query dont update

    I don't have any problems if I have set queries to refresh on opening. Without seeing your workbook, it's really hard to guess what the problem might be. However, if the query that is not updating is dependent on another that hasn't been refreshed, then this might be your problem, but it is only a stab in the dark.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2019 Power Query update
    By Jiggers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2020, 09:16 PM
  2. Scheduling Power Query to Update File
    By wherdzik in forum Excel General
    Replies: 1
    Last Post: 03-28-2020, 09:02 PM
  3. [SOLVED] Power Query - update particular columns
    By afgi in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 02-16-2020, 06:41 PM
  4. Select sheet after Power Query Update
    By jonrack in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-05-2019, 02:16 PM
  5. Update pivot tables without refreshing power query
    By Acceptablerisk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2019, 04:48 AM
  6. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  7. Power Query Won't Update
    By Justair07 in forum Excel General
    Replies: 9
    Last Post: 09-29-2016, 04:46 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1