{"id":175,"date":"2013-10-22T22:56:10","date_gmt":"2013-10-22T19:56:10","guid":{"rendered":"http:\/\/meekconsulting.com\/?p=175"},"modified":"2022-01-08T16:26:32","modified_gmt":"2022-01-08T13:26:32","slug":"stop-ie-from-prompting-for-passwords-on-download-of-excel","status":"publish","type":"post","link":"https:\/\/meekconsulting.com\/?p=175","title":{"rendered":"Stop IE from prompting for passwords on download of excel"},"content":{"rendered":"<p>We finally came up with a solution for the IE prompts for PIN multiple times and passwrods.<\/p>\n<p>\u00a0<\/p>\n<p>The solution turned out to be adding a Content Header \u00a0to treat the xls files as \u201cAttachements\u201d\u00a0 \u2014 this way IE doesn\u2019t try to open see if it can open for \u201cediting\u201d\u00a0 instead it just gives the user the dialog to open or save choice \u2013 If they choose open it just pops open without any delay or extra pin prompts J<\/p>\n<p>\u00a0<\/p>\n<p>Here is the Microsoftt page that gave us this IDEA:<br \/>\n<a href=\"http:\/\/support.microsoft.com\/kb\/899927\">http:\/\/support.microsoft.com\/kb\/899927<\/a><\/p>\n<p>\u00a0<\/p>\n<p>Which we found from here:<\/p>\n<p><a href=\"http:\/\/support.microsoft.com\/kb\/2019105\/en-us\">http:\/\/support.microsoft.com\/kb\/2019105\/en-us<\/a><\/p>\n<p>\u00a0<\/p>\n<p>The Apache \/etc\/httpd\/conf\/httpd.conf change we made to fix this is here:<\/p>\n<p>\u00a0<\/p>\n<p>First \u2013 make sure the mod_headers module is loaded and then add the yellow below.<\/p>\n<p>\u00a0<\/p>\n<p>LoadModule headers_module modules\/mod_headers.so<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<blockquote><p><DirectoryMatch \u201c\/stars\/xlsfiles\u201d><\/p>\n<p>Order allow,deny<\/p>\n<p>Allow from all<\/p>\n<p><LimitExcept GET POST HEAD><\/p>\n<p>Deny from all<\/p>\n<p><\/LimitExcept><\/p>\n<p><IfModule mod_headers.c><\/p>\n<p>Header set Content-Disposition attachment<\/p>\n<p><\/IfModule><\/p>\n<p><\/DirectoryMatch><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>We finally came up with a solution for the IE prompts for PIN multiple times and passwrods. \u00a0 The solution turned out to be adding a Content Header \u00a0to treat the xls files as \u201cAttachements\u201d\u00a0 \u2014 this way IE doesn\u2019t &hellip; <a href=\"https:\/\/meekconsulting.com\/?p=175\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/posts\/175"}],"collection":[{"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=175"}],"version-history":[{"count":2,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/posts\/175\/revisions"}],"predecessor-version":[{"id":178,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/posts\/175\/revisions\/178"}],"wp:attachment":[{"href":"https:\/\/meekconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}