After starting the Excel Import Wizard and setting the filename, you click next or save and the cpu of the computer fires-up to 100% and nothing happens. It takes a long time (about 20 min) for the next window to appear.
In the Excel sheet you try to import, there are a lot of empty rows which Wizard tries to import. You can determine the used range by pressing Ctrl+End on keyboard.
- Left-click at first empty row in Excel
- Go to the last row and press shift+left-click and select all unused rows.
- Right-click and select “delete”.
- Save the file.