Excel 2010+ and basic authentication of data sources
Lets say you have an XML data source and you access it with VBA or thorugh a sheet with a data source already preset once and it worked. Note that this assumes that the link is behind a popup to enter your username/password (Basic Authentication) The next time you go into that sheet or run the macro to refetch the information – you will get an error or no data.
Microsoft in short, has disallowed basic authentication for non-SLL urls. In my case Report Services (SSRS) is an intranet url that does not have SSL or does not begin with HTTPS nor has it been set up that way by IT – so … Office 2010+ products will not work unless you do a registry tweak or enable SSL on the source computer’s SSRS. So do ONE of the following