{"id":586,"date":"2012-09-28T15:16:34","date_gmt":"2012-09-28T19:16:34","guid":{"rendered":"http:\/\/blogs.butler.edu\/mybutlerhelp\/?post_type=question&p=586"},"modified":"2012-10-11T18:41:00","modified_gmt":"2012-10-11T22:41:00","slug":"how-do-i-save-and-filter-query-results-with-microsoft-excel-on-my-windows-pc","status":"publish","type":"question","link":"http:\/\/blogs.butler.edu\/mybutlerhelp\/question\/how-do-i-save-and-filter-query-results-with-microsoft-excel-on-my-windows-pc\/","title":{"rendered":"How do I save and filter query results with Microsoft Excel on my Windows PC?"},"content":{"rendered":"

Queries can be retrieved by logging into the My.Butler<\/em> portal and navigating to CS Tools<\/strong> > Query Viewer<\/strong>. Enter then name of an existing query and hit the \u2018Search\u2019 button to retrieve your desired query. To the right of the query in the results list are two links: \u2018HTML,\u2019 which displays the results on the screen; and \u2018Excel,\u2019 which opens the results in an MS-Excel spreadsheet.<\/p>\n

\"Query<\/a><\/p>\n

Windows PC users may notice that when they click on the \u2018Excel\u2019 link, the query\u2019s results display in a spreadsheet in the browser without the customary Excel toolbars that make saving and manipulating the data easier.<\/p>\n

\"MS-Excel<\/a><\/p>\n

You can force your browser to open the query results as a spreadsheet with the toolbar intact by changing a Windows setting as described below.<\/p>\n

    \n
  1. Go to the \u2018Start\u2019 menu and locate the \u2018Control Panel\u2019 under \u2018Settings.\u2019<\/li>\n
  2. On the \u2018Tools\u2019 menu, select \u2018Folder Options.\u2019<\/li>\n
  3. Click on the \u2018File Types\u2019 tab.<\/li>\n
  4. In the list of file types, scroll down until you find the .xls extension for a Microsoft Excel worksheet. Click on the .xls type.<\/li>\n
  5. Click on the \u2018Advanced\u2019 button.<\/li>\n
  6. In the Edit dialog box that appears, uncheck the box by the \u2018Browse in Same Window\u2019 option.<\/li>\n
  7. Click OK to close the window and save the changes, then close the Folder Options window.<\/li>\n<\/ol>\n

    These steps will allow Excel to open in its own window instead of inside the browser window when you click on the ‘Excel’ link for query results.<\/p>\n

    \"An<\/a><\/p>\n","protected":false},"author":253,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"faq-topic":[114258,114253],"faq-tags":[],"class_list":["post-586","question","type-question","status-publish","hentry","faq-topic-student-data","faq-topic-technical-information","nodate","item-wrap"],"_links":{"self":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/questions\/586","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=586"}],"wp:attachment":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/media?parent=586"}],"wp:term":[{"taxonomy":"faq-topic","embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/faq-topic?post=586"},{"taxonomy":"faq-tags","embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/faq-tags?post=586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}