none
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 :)


    Merv

    Monday, September 16, 2019 11:44 AM

All replies

  • 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
    Tuesday, September 17, 2019 12:05 PM