Help me solve this Excel Power Query editor issue

This sounds a lot like an issue with the installation of Power Query, or an issue where an add-in is interfering.

I would do these in order (at each step starting from 4, repeat steps 1-3):

1. New blank workbook.
2. Enter a tiny table
3. On the Data tab, click "From Table/Range"
4. If it crashes again:
   • Start Excel in Safe Mode (close Excel first. Then hold down the Control key while Excel starts).
5. If it still crashes:
   • Disable all COM add-ins:
     File, Options, Add-ins, at the bottom choose COM add-ins in the drop-down and click the Go... button. Uncheck all of them after noting which were checked
6. If it still crashes:
   • Clear Power Query cache:
     Open Windows Explorer and paste this into the address bar: %LOCALAPPDATA%\Microsoft\Office\16.0\PowerQuery
     and press Enter. Delete the content of that folder (or to be on the safer side, rename the folder itself so PowerQuery can rename it)
7. If that doesn't help, do an Office Quick Repair using Office setup from settings, Software
8. If that doesn't help, do an Office Online Repair using Office setup from settings, Software