Jun 11 2019
01:00 AM
- last edited on
Jul 12 2019
11:25 AM
by
TechCommunityAP
Jun 11 2019
01:00 AM
- last edited on
Jul 12 2019
11:25 AM
by
TechCommunityAP
As of today, the Power Query Editor window, on MS Excel 2013, has been very slow to open, even on a blank workbook with no data, no queries written. Upwards of three minutes just to show an empty editor window. I have tried
Running a refresh on a simple query that has previously taken less than 30 seconds, now takes upwards of 10 minutes. No errors are shown and the results are all OK.
Any suggestions on what to look for?
Cheers
Graham
Jun 18 2019 07:07 AM
Have you tried fast data loading option, Query option> data load.
if that does not help, please check your RAM size, even though an empty query shouldn't be affected by this. Using 64bit?