{"id":1123,"date":"2015-05-01T16:50:14","date_gmt":"2015-05-01T16:50:14","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=1123"},"modified":"2022-02-03T11:24:58","modified_gmt":"2022-02-03T17:24:58","slug":"excel-2010-and-basic-authentication-of-data-sources","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/","title":{"rendered":"Excel 2010+ and basic authentication of data sources"},"content":{"rendered":"<p>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 &#8211; you will get an error or no data.<\/p>\n<p>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 &#8211; so &#8230; Office 2010+ products will not work unless you do a registry tweak or enable SSL on the source computer&#8217;s SSRS. So do ONE of the following<\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-ca\/kb\/2123563\" target=\"_blank\" rel=\"noopener noreferrer\">Client side adjustment (not ideal)<\/a><\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms345223(v=sql.110).aspx\" target=\"_blank\" rel=\"noopener noreferrer\">SSRS Server computer adjustment<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1123","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel 2010+ and basic authentication of data sources - ELB Solutions.com Inc.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel 2010+ and basic authentication of data sources - ELB Solutions.com Inc.\" \/>\n<meta property=\"og:description\" content=\"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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/\" \/>\n<meta property=\"og:site_name\" content=\"ELB Solutions.com Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-01T16:50:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-03T17:24:58+00:00\" \/>\n<meta name=\"author\" content=\"Etienne Bley\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Etienne Bley\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/excel-2010-and-basic-authentication-of-data-sources\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/excel-2010-and-basic-authentication-of-data-sources\\\/\"},\"author\":{\"name\":\"Etienne Bley\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"headline\":\"Excel 2010+ and basic authentication of data sources\",\"datePublished\":\"2015-05-01T16:50:14+00:00\",\"dateModified\":\"2022-02-03T17:24:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/excel-2010-and-basic-authentication-of-data-sources\\\/\"},\"wordCount\":157,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/excel-2010-and-basic-authentication-of-data-sources\\\/\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/excel-2010-and-basic-authentication-of-data-sources\\\/\",\"name\":\"Excel 2010+ and basic authentication of data sources - ELB Solutions.com Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\"},\"datePublished\":\"2015-05-01T16:50:14+00:00\",\"dateModified\":\"2022-02-03T17:24:58+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/excel-2010-and-basic-authentication-of-data-sources\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/excel-2010-and-basic-authentication-of-data-sources\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/excel-2010-and-basic-authentication-of-data-sources\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel 2010+ and basic authentication of data sources\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\",\"name\":\"ELB Solutions.com Inc.\",\"description\":\"Bringing all your IT Pieces together\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\",\"name\":\"Etienne Bley\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"caption\":\"Etienne Bley\"},\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/author\\\/etienne-bley\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel 2010+ and basic authentication of data sources - ELB Solutions.com Inc.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/","og_locale":"en_US","og_type":"article","og_title":"Excel 2010+ and basic authentication of data sources - ELB Solutions.com Inc.","og_description":"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 [&hellip;]","og_url":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/","og_site_name":"ELB Solutions.com Inc.","article_published_time":"2015-05-01T16:50:14+00:00","article_modified_time":"2022-02-03T17:24:58+00:00","author":"Etienne Bley","twitter_misc":{"Written by":"Etienne Bley","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/#article","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/"},"author":{"name":"Etienne Bley","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"headline":"Excel 2010+ and basic authentication of data sources","datePublished":"2015-05-01T16:50:14+00:00","dateModified":"2022-02-03T17:24:58+00:00","mainEntityOfPage":{"@id":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/"},"wordCount":157,"articleSection":["General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/","url":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/","name":"Excel 2010+ and basic authentication of data sources - ELB Solutions.com Inc.","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/#website"},"datePublished":"2015-05-01T16:50:14+00:00","dateModified":"2022-02-03T17:24:58+00:00","author":{"@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"breadcrumb":{"@id":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/elbsolutions.com\/projects\/excel-2010-and-basic-authentication-of-data-sources\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elbsolutions.com\/projects\/"},{"@type":"ListItem","position":2,"name":"Excel 2010+ and basic authentication of data sources"}]},{"@type":"WebSite","@id":"https:\/\/elbsolutions.com\/projects\/#website","url":"https:\/\/elbsolutions.com\/projects\/","name":"ELB Solutions.com Inc.","description":"Bringing all your IT Pieces together","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elbsolutions.com\/projects\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39","name":"Etienne Bley","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","caption":"Etienne Bley"},"url":"https:\/\/elbsolutions.com\/projects\/author\/etienne-bley\/"}]}},"_links":{"self":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/comments?post=1123"}],"version-history":[{"count":2,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1123\/revisions"}],"predecessor-version":[{"id":2743,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1123\/revisions\/2743"}],"wp:attachment":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/media?parent=1123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/categories?post=1123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/tags?post=1123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}