none
High CPU after above 9106 Excel Files loading in Power Query is Hanging with High CPU RRS feed

  • Question

  • Hi folks,

    I'm loading 9106 Rows (Reading 3940 Excel Files) as a part of the New Power Query in Excel. I can get 3000 Excel files loaded and "Load/Closed" without any issues; however, it is around 3940 Excel files that I get a very high CPU running on my heavy duty laptop of 12 Logical CPUs. Withiin Power Query, there are 6-7 Queries but none very intense. 

    The MS Mashup Evaluation kicks in as couple of the Processes under the EXCEL one running at 96% CPU utilization.

    I'm not sure what's causing this issue. 

    Pls help if you could.



    • Edited by GoMSACCESS Monday, November 18, 2019 5:49 PM
    Monday, November 18, 2019 5:46 PM