Forum Discussion
Excel Get Data from Web (Legacy) connection issues
Hi everyone, I have am looking to import data from a web page and need to use the Get Data -> from Web (legacy) system, since the new Power Query option does not support proxy authentication. ...
For those having this issues - It seems that excel is cutting off the URL's at 115 characters. One way around this is to change your file type to the 97-2003 version: ".xls"
Below is the link that I found this workaround at. If anyone finds another way to fix this issue in Excel 2016, please let me know!