power query auto refresh in the background RRS feed

  • Question

  • i am trying a find a way to auto refresh power queries in Excel in the background

    currently am pulling data from sharepoint and it takes too long to refresh the data

    I can't use excel while refresh is happening. any suggestions?

    Thanks in advance folks :)


    Monday, September 16, 2019 11:44 AM


  • Open a second instance of Excel. From memory, hold Alt, right click in the Excel logo in the task bar and then you can open a new instance.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    • Edited by Matt AllingtonMVP Tuesday, September 17, 2019 12:06 PM
    • Proposed as answer by SamNaik Thursday, September 19, 2019 4:12 AM
    • Marked as answer by Imke FeldmannMVP Saturday, October 26, 2019 6:18 AM
    Tuesday, September 17, 2019 12:05 PM