{"id":607,"date":"2012-10-22T13:09:56","date_gmt":"2012-10-22T17:09:56","guid":{"rendered":"http:\/\/blogs.butler.edu\/mybutlerhelp\/?post_type=question&#038;p=607"},"modified":"2012-10-22T13:09:56","modified_gmt":"2012-10-22T17:09:56","slug":"how-do-i-get-ms-excel-to-open-a-file-with-my-results-when-i-click-on-the-excel-link-in-query-viewer","status":"publish","type":"question","link":"http:\/\/blogs.butler.edu\/mybutlerhelp\/question\/how-do-i-get-ms-excel-to-open-a-file-with-my-results-when-i-click-on-the-excel-link-in-query-viewer\/","title":{"rendered":"How do I get MS-Excel to open a file with my results when I click on the &#8216;Excel&#8217; link in Query Viewer?"},"content":{"rendered":"<p>If you&#8217;re using Internet Explorer as your browser, you may not be able to save your query results to an Excel document by clicking on the &#8216;Excel&#8217; link in Query Viewer. When you click on the link, you may initially see a popup window that quickly disappears from view, or an error message.<\/p>\n<p>Enabling this link requires the addition of the Butler domain to your list of local intranet trusted sites in your browser&#8217;s security settings. Follow the steps below to correct this issue.<\/p>\n<ol>\n<li>Open Internet Explorer and from the main menu, select <em>Tools &gt; Internet Options.<\/em><\/li>\n<li>Click on the <strong>Security<\/strong> tab.<\/li>\n<li>Click on zone labeled \u201cLocal intranet\u201d to select it, then click the <strong>Sites<\/strong> button.<\/li>\n<li>In the resulting pop up window, click on the <strong>Advanced<\/strong> button.<\/li>\n<li>Add the following websites to the \u201cLocal intranet\u201d sites:\n<ul>\n<ul>\n<li>http:\/\/*.butler.edu<\/li>\n<li>https:\/\/*.butler.edu<\/li>\n<\/ul>\n<\/ul>\n<p><a href=\"http:\/\/blogs.butler.edu\/mybutlerhelp\/files\/2012\/09\/local_intranet.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-186\" src=\"http:\/\/blogs.butler.edu\/mybutlerhelp\/files\/2012\/09\/local_intranet.gif\" alt=\"Local intranet settings displaying the Butler domain address additions.\" width=\"384\" height=\"342\" srcset=\"http:\/\/blogs.butler.edu\/mybutlerhelp\/files\/2012\/09\/local_intranet.gif 384w, http:\/\/blogs.butler.edu\/mybutlerhelp\/files\/2012\/09\/local_intranet-300x267.gif 300w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><\/a><\/li>\n<li>Once added, click <strong>Close<\/strong>, then click <strong>OK<\/strong>. With the \u201cLocal intranet\u201d zone still highlighted, click the <strong>Custom level\u2026<\/strong> button.<\/li>\n<li>Scroll down until you find the <em>Downloads<\/em> heading.\u00a0 Find <em>Automatic prompting for file downloads<\/em> and ensure this is set to <strong><em>Enable<\/em><\/strong>.<\/li>\n<li>Scroll down further until you find the <em>Miscellaneous<\/em> heading.\u00a0 Find <em>Use Pop-up Blocker<\/em> and ensure this is set to <em><strong>Disable<\/strong><\/em>.<\/li>\n<li>Click OK to save these setting changes and close the window. Clicking on the Excel link in Query Viewer should now work.<\/li>\n<\/ol>\n","protected":false},"author":253,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"faq-topic":[114261,114253],"faq-tags":[],"class_list":["post-607","question","type-question","status-publish","hentry","faq-topic-for-faculty-and-staff","faq-topic-technical-information","nodate","item-wrap"],"_links":{"self":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/questions\/607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/users\/253"}],"replies":[{"embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/comments?post=607"}],"wp:attachment":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/media?parent=607"}],"wp:term":[{"taxonomy":"faq-topic","embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/faq-topic?post=607"},{"taxonomy":"faq-tags","embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/faq-tags?post=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}