Home

Power Query Editor window slow to open.

%3CLINGO-SUB%20id%3D%22lingo-sub-682502%22%20slang%3D%22en-US%22%3EPower%20Query%20Editor%20window%20slow%20to%20open.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682502%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20of%20today%2C%20the%20Power%20Query%20Editor%20window%2C%20on%20MS%20Excel%202013%2C%20has%20been%20very%20slow%20to%20open%2C%20even%20on%20a%20blank%20workbook%20with%20no%20data%2C%20no%20queries%20written.%20Upwards%20of%20three%20minutes%20just%20to%20show%20an%20empty%20editor%20window.%20I%20have%20tried%3C%2FP%3E%3CUL%3E%3CLI%3EUninstall%20and%20install%20the%20latest%20version%20of%20PQ%20(2.62.5222.701%2032-bit)%3C%2FLI%3E%3CLI%3ERepair%20MS%20Office%3C%2FLI%3E%3CLI%3EStop%20MS%20Teams%20running%20as%20a%20new%20version%20installed%3C%2FLI%3E%3CLI%3EChecked%20Anti-virus%20-%20could%20not%20see%20anything%20that%20would%20impede%20performance%3C%2FLI%3E%3C%2FUL%3E%3CP%3ERunning%20a%20refresh%20on%20a%20simple%20query%20that%20has%20previously%20taken%20less%20than%2030%20seconds%2C%20now%20takes%20upwards%20of%2010%20minutes.%20No%20errors%20are%20shown%20and%20the%20results%20are%20all%20OK.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20on%20what%20to%20look%20for%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGraham%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-682502%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eexcel%202013%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-699766%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Editor%20window%20slow%20to%20open.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699766%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20tried%20fast%20data%20loading%20option%2C%20Query%20option%26gt%3B%20data%20load.%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20that%20does%20not%20help%2C%20please%20check%20your%20RAM%20size%2C%20even%20though%20an%20empty%20query%20shouldn't%20be%20affected%20by%20this.%20Using%2064bit%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Graham Co
Senior Member

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

  • Uninstall and install the latest version of PQ (2.62.5222.701 32-bit)
  • Repair MS Office
  • Stop MS Teams running as a new version installed
  • Checked Anti-virus - could not see anything that would impede performance

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

1 Reply

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?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies