Forum Discussion
Power Query Editor Steps are painfully slow
Uncheck all the settings where Power Query tries to mess with the meta data (column type inference, relationship detection etc.) Uncheck anything you don't want Power Query to do for you.
Same issue here. I had 13 columns and 635 rows all pulling from a table within workbook. It took a few minutes just clicking between already applied steps. I deleted all named ranges but first, I had to unhide all hidden ones. To do that you need a bit of VBA code which I found online (https://excelhelphq.com/how-to-unhide-or-delete-name-ranges-in-excel/).
Alt+F11 -> Insert -> Module then paste in following code:
Sub ShowAllNames()
Dim n As Name
For Each n In ActiveWorkbook.Names
n.Visible = True
Next n
End Sub
Close the window and press F5 to run the macro. Close the VBA editor. Go to Formulas in the ribbon and select Name Manager from Defined Names section. Delete all the carp from here. Bear in mind that all you tables, print areas, fitlers etc. are also saved here so be carefull deleting everything.
Hope this will work for you too.