{"id":569,"date":"2011-01-25T15:29:09","date_gmt":"2011-01-25T15:29:09","guid":{"rendered":"http:\/\/pariswells.com\/blog\/?p=569"},"modified":"2011-01-25T15:29:09","modified_gmt":"2011-01-25T15:29:09","slug":"add-sage-eir-add-in-for-excel-sage-excel-intergrated-reporting","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/notes\/add-sage-eir-add-in-for-excel-sage-excel-intergrated-reporting","title":{"rendered":"Add Sage EIR add in for Excel sage excel intergrated reporting"},"content":{"rendered":"<a href=\"http:\/\/pariswells.com\/blog\/wp-content\/uploads\/2011\/01\/01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-570 img-responsive\" title=\"0[1]\" src=\"http:\/\/pariswells.com\/blog\/wp-content\/uploads\/2011\/01\/01-300x225.jpg\" alt=\"\" width=\"300\" height=\"225\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2011\/01\/01-300x225.jpg 300w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2011\/01\/01.jpg 480w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>The Sage Accounts add in for Excel requires 2 Add Ins to be Enabled. One is called the Sage EIR add in and the other is Sage Report Designer for 97. Even for Office 2007 the Sage Report Designer still needs to be enabled. For the add in to show and work you might need to add these Files Manually\r\n\r\n<strong>Sage EIR add in<\/strong>\r\n\r\nGo to Excel , Options , Add-In&#8217;s\r\n\r\nGo to manage &#8220;Excel Add Ins&#8221; , Then tick &#8220;Sage EIR add in&#8221;. If this is not in the list, click on browse and search for this file. You will have to change the drop down of &#8220;File Type&#8221; from XLA Excel Addin&#8217;s to &#8220;All Files&#8221;\r\n\r\nC:\\Windows\\system32\\SGXLADDIN.dll\r\n\r\n<strong>Sage Report Designer for 97<\/strong>\r\n\r\nGo to Excel , Options , Add-In&#8217;s\r\n\r\nGo to manage &#8220;Excel Add Ins&#8221; , Then tick &#8220;Sage EIR add in&#8221;. If this is not in the list, click on browse and search for XLA&#8217;s in the directory\r\n\r\nC:\\Windows\\system32\\\r\n\r\nAdd any XLA&#8217;s and enable them\r\n\r\nOnce these have been added and enabled you should see the Sage Report Wizard in Add In&#8217;s. One thing , if you click on Sage Account Line , ( in the add in toolbar) and go to About the version to access Sage Line 2007 Data should be 2.0.0.34. When you install a new version of Sage Accounts , this file gets upgraded to 2.0.0.39 which does not work with Sage Account 2007. So you will need to uninstall any newer versions and reinstall older versions to be able to report data in Excel","protected":false},"excerpt":{"rendered":"<p>The Sage Accounts add in for Excel requires 2 Add Ins to be Enabled. One is called the Sage EIR add in and the other is Sage [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[339,338,340,341],"class_list":["post-569","post","type-post","status-publish","format-standard","hentry","category-notes","tag-cwindowssystem32sgxladdin-dll","tag-sage-eir-add-in","tag-sage-excel-addins","tag-sage-reporting-in-excel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=569"}],"version-history":[{"count":2,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/569\/revisions"}],"predecessor-version":[{"id":1016,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/569\/revisions\/1016"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}