Please help! Excel 2016 truncates URL of REST API call to import XML data
Dear all, I have created a number of Excelsheets that are using calls to a REST API for importing tables into the Workbook. (Through Developer Tools -> XML -> Import and then entering the URL.) I created these workbooks in Excel 2010 and they continue to update fine when I click "Refresh data" or "Refresh all" in Excel 2010 - but in Excel 2016 the URL gets truncated which leads to an error message and the data not getting updated. I would be extremely grateful for any pointers as to how this can be resolved. Thank you very much in advance for any help you may be able to provide. All the best, Stefan
