Solved, well sort of.

After a 2 hour support call with Microsoft, they couldn't get it to work either.

But, instead of using "Connect to a new data source", I can just select the Excel workbook from the list of files in the LH pane . That works.