{"id":79705,"date":"2022-06-13T08:36:00","date_gmt":"2022-06-13T08:36:00","guid":{"rendered":"https:\/\/accountingerrors.com\/sage\/?p=79697"},"modified":"2025-02-28T07:05:15","modified_gmt":"2025-02-28T07:05:15","slug":"sage-50-excel-macros-not-working","status":"publish","type":"post","link":"https:\/\/www.bigxperts.com\/sage\/sage-50-excel-macros-not-working\/","title":{"rendered":"Troubleshoot Sage 50 Connection Error with Microsoft Excel"},"content":{"rendered":"\n<p>An Excel macro is an action or a set of actions that you can record, give a name, save, and run as many times and whenever you want.&nbsp; Macros help you save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently.<\/p>\n\n\n\n<p>When data, including invoices, bank statements, receipts, and more is exported from Sage 50 to Microsoft Excel, &amp; it fails or is unexpected an error occurs which is the &#8220;connection issues with MS Excel&#8221;. To Resolve this particular Sage 50 connection issues with Microsoft Excel the settings have to be set back to default.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Post Navigation<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-excel-macros-not-working\/#methods-to-resolve-sage-50-connection-error-with-microsoft-excel\" >Methods To Resolve Sage 50 Connection Error with Microsoft Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-excel-macros-not-working\/#method-1-to-view-the-current-trusted-locations-or-add-a-new-one\" >Method 1: To view the current trusted locations or add a new one<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-excel-macros-not-working\/#method-2-set-back-to-default-settings\" >Method 2: Set back to default settings&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-excel-macros-not-working\/#method-3-problematic-macros\" >Method 3: Problematic Macros<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-excel-macros-not-working\/#closure\" >Closure<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-excel-macros-not-working\/#frequently-asked-questions\" >Frequently Asked Questions<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"methods-to-resolve-sage-50-connection-error-with-microsoft-excel\"><\/span>Methods To Resolve Sage 50 Connection Error with Microsoft Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You can easily configure Excel to trust specific locations on your computer or local network instead of manipulating the global macro settings. Any Excel file in a trusted location opens with macros enabled and without security warnings. Even if the Disable all macros without notification option is chosen in the Trust Centre Settings. This lets you run macros in certain workbooks when all other Excel macros are disabled.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"method-1-to-view-the-current-trusted-locations-or-add-a-new-one\"><\/span>Method 1: To view the current trusted locations or add a new one<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to Excel and then open File, Options.<\/li>\n\n\n\n<li>On the left-hand pane, click Trust Centre and then Trust Centre Settings.<\/li>\n\n\n\n<li>In the Trust Centre dialog box, navigate to the Trusted Locations on the left side. Here, you will view a list of the default trusted locations. These locations are important for the correct work of Excel add-ins, macros, and templates and should not be changed anyhow. Technically, you can save your workbook to one of the Excel default locations but it\u2019s better to create your own one.&nbsp;<\/li>\n\n\n\n<li>Give a click on Add new location if you are willing to set up your trusted location.&nbsp;&nbsp;<\/li>\n\n\n\n<li>In the Microsoft Office Trusted Locations dialog box, you need to do the following:\n<ul class=\"wp-block-list\">\n<li>Press the Browse button to hover over the folder that you want to make a trusted location.&nbsp;<\/li>\n\n\n\n<li>If you wish any subfolder of the selected folder to be trusted too, verify the subfolders of this location are also trusted boxes.&nbsp;<\/li>\n\n\n\n<li>Enter a short notice in the Description field (it can help you manage multiple locations) or leave it empty.&nbsp;<\/li>\n\n\n\n<li>Hit OK.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Press OK twice to close the remaining dialog boxes.<\/li>\n<\/ul>\n\n\n\n<p>Now, you can place your workbook with macros in your trusted location and won\u2019t bother about Excel Security Settings.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"method-2-set-back-to-default-settings\"><\/span>Method 2: Set back to default settings&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>To set the default settings read the mentioned steps below:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If in case the above-listed steps don\u2019t work, restore the defaults for the Excel program in the Control Panel.<\/li>\n\n\n\n<li>Next, reboot your computer.<\/li>\n\n\n\n<li>In the end, once again try to open a report in Sage 50.&nbsp;<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"method-3-problematic-macros\"><\/span>Method 3: Problematic Macros<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If you are facing certain issues with Macros go through the given steps below: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the Step Into button to access the Macro in which you are facing issues.<\/li>\n\n\n\n<li>To step through Macro, the VBA Editor must have opened up.<\/li>\n\n\n\n<li>Now you need to press the F8 key to continue.<\/li>\n\n\n\n<li>Exit the \u201cStep Into\u201d mode and attempt to fix the macro code if the macro encounters a problem and then repeat the \u201cStep Into\u201d process once again.&nbsp;<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Automatically Running Macros:<\/h4>\n\n\n\n<p>Macros can be very powerful for doing many different things in Excel (e.g. formatting, filtering, and securing data.) This makes the report one step closer to being ready to go as soon as it\u2019s out.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open your report manager.<\/li>\n\n\n\n<li>Select the report that you want the macro to run in, run the report, or open the Excel template in Design mode.&nbsp;<\/li>\n\n\n\n<li>Generate the macro you want to run automatically, ensuring that in your macro you specify which sheet you need the macro to work in. (it will help by forcing the macro to choose the correct sheet even after you Create and Link the workbook with a different active sheet.<\/li>\n\n\n\n<li>When you have created and tested your macro, save the template or create and link the workbook back to the report.<\/li>\n\n\n\n<li>Under the properties tab, tick the Show Advanced option at the bottom of the screen and Highlight the report in which you have designed the macro<\/li>\n\n\n\n<li>In the advanced options list that is now available, locate the Run Macros on Completion option. In the text box type the name of the macro you created.<\/li>\n\n\n\n<li>Finally, exiting the VBA Editor troubleshooting mode.<\/li>\n\n\n\n<li>Make sure you Apply the changes to the report, once you have entered the name of the macro.&nbsp;<\/li>\n\n\n\n<li>At last, run the report out and your macro will automatically run.&nbsp;<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>Read More<\/em><\/strong>: <a href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-export-to-excel-not-working\/\">Fix Sage 50 Export to Excel Not Working Issue<\/a><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"closure\"><\/span>Closure<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Hopefully, these write-up invoices are helpful for you but if in case, the issue has persisted and you are unable to resolve it alone, feel free to get in touch with the Sage 50 professional experts. They are always available to help you with instant and cutting-edge solutions. So, don\u2019t be upset if your system doesn\u2019t allow you to proceed as you can get in touch with us through <a href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-live-chat\/\">Sage 50 Live Chat<\/a> for quicker and better assistance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"frequently-asked-questions\"><\/span>Frequently Asked Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-3733d40c uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-9e3e9253 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>What&#8217;s the Reason Behind the MS Excel Macros Not Working in Sage50?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>This Sage 50 Error often occurs due to saving a file type that has been blocked by File Block settings in the Trust Centre in Excel.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-8e701965 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>How to Turn on Excel Macro in Backstage View in Sage 50 Accounts?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Generally, there are two ways to enable macros for certain files; either directly from the workbook or through the backstage view.<br>Press the file tab then select info in the left menu.<br>Move towards the Security Warning area and click Enable All Content.<\/p><\/div><\/div><\/div>\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-a9062498 uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><\/div>\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-529e3dad uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><\/div>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>An Excel macro is an action or a set of actions that you can record, give a name, save, and run as many times and whenever you want.&nbsp; Macros help you save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently. When data, including invoices, bank&hellip;&nbsp;<a href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-excel-macros-not-working\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Troubleshoot Sage 50 Connection Error with Microsoft Excel<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":85586,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[7],"tags":[20,13,21],"class_list":["post-79705","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sage-errors","tag-excel-macros-not-working","tag-sage-50","tag-sage-50-excel-macros-not-working"],"featured_image_src":"https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working.jpg","author_info":{"display_name":"Rick","author_link":"https:\/\/www.bigxperts.com\/sage\/author\/robert\/"},"uagb_featured_image_src":{"full":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working.jpg",840,300,false],"thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working-150x150.jpg",150,150,true],"medium":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working-300x107.jpg",300,107,true],"medium_large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working-768x274.jpg",768,274,true],"large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working.jpg",840,300,false],"1536x1536":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working.jpg",840,300,false],"2048x2048":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working.jpg",840,300,false],"neve-blog":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working.jpg",840,300,false],"web-stories-poster-portrait":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working-640x300.jpg",640,300,true],"web-stories-publisher-logo":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working-96x96.jpg",96,96,true],"web-stories-thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/Sage-Excel-Macros-Not-Working-150x54.jpg",150,54,true]},"uagb_author_info":{"display_name":"Rick","author_link":"https:\/\/www.bigxperts.com\/sage\/author\/robert\/"},"uagb_comment_info":0,"uagb_excerpt":"An Excel macro is an action or a set of actions that you can record, give a name, save, and run as many times and whenever you want.&nbsp; Macros help you save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently. When data, including invoices, bank&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/79705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/comments?post=79705"}],"version-history":[{"count":3,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/79705\/revisions"}],"predecessor-version":[{"id":86871,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/79705\/revisions\/86871"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media\/85586"}],"wp:attachment":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media?parent=79705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/categories?post=79705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/tags?post=79705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}