I'm trying to import an online spreadsheet (.xls) into Excel. ie. Copy data from that spreadsheet into my current workbook. Data import fails as it only works for webpages.
I know I can simply download the spreadsheet, copy the data across, but this would encounter problems for multiple spreadsheets.