{"id":82528,"date":"2025-03-12T05:09:02","date_gmt":"2025-03-12T05:09:02","guid":{"rendered":"https:\/\/www.bigxperts.com\/sage\/?p=82528"},"modified":"2025-07-17T10:47:40","modified_gmt":"2025-07-17T10:47:40","slug":"fix-error-sagebi-excelfunctions11xll-dont-match","status":"publish","type":"post","link":"https:\/\/www.bigxperts.com\/sage\/fix-error-sagebi-excelfunctions11xll-dont-match\/","title":{"rendered":"How to Fix Sage.BI.ExcelFunctions1.1.Xll Don&#8217;t Match File Format Issue"},"content":{"rendered":"\n<p>Sage 50 intelligence report requires a report designer add-in to use the Excel functions plugin. If you don\u2019t have the add-in installed with your Sage intelligence reporting, you\u2019ll receive the error &#8220;#NAME&#8221; or &#8220;#NAME?&#8221; displayed in Excel. The error states, \u201cThe file format and extension of \u201c<strong>Sage.BI.ExcelFunctions1.1.xll<\/strong>&#8221; don\u2019t match. This is specifically because of the missing designer add-on. Fixing the error requires you to <a href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-installation-instructions\/\">install the Sage 50<\/a> report designer, and then configure Microsoft Excel so that both programs can work together without creating conflicts that lead to errors.<\/p>\n\n\n\n<p>In this post, you\u2019ll learn how to fix the Sage 50 error the file format and extension of \u201cSage .BI.ExcelFunctions1.1.xll\u201d don\u2019t match the issue.<\/p>\n\n\n\n<p><strong>The exact error message is shown<\/strong>&#8230;<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>The file format and extension of &#8216;Sage.BI.ExcelFunctions1.1.xll&#8217; don&#8217;t match.<\/p>\n<\/blockquote>\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\/fix-error-sagebi-excelfunctions11xll-dont-match\/#causes-of-the-error-sage-biexcelfunctions11xll\" >Causes of the Error: Sage .BI.ExcelFunctions1.1.xll<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.bigxperts.com\/sage\/fix-error-sagebi-excelfunctions11xll-dont-match\/#solutions-for-sage-biexcelfunctions11xll%e2%80%9d-dont-match-issue\" >Solutions for Sage .BI.ExcelFunctions1.1.Xll\u201d Don\u2019t Match Issue&nbsp;<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.bigxperts.com\/sage\/fix-error-sagebi-excelfunctions11xll-dont-match\/#solution-1-install-report-designer-add-in\" >Solution 1: Install Report Designer add-in<\/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\/fix-error-sagebi-excelfunctions11xll-dont-match\/#solution-2-configure-the-sage-50-report-designer-add-in\" >Solution 2: Configure the Sage 50 Report Designer Add-in<\/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\/fix-error-sagebi-excelfunctions11xll-dont-match\/#solution-3-reinstall-the-report-designer-add-in\" >Solution 3: Reinstall the report designer add-in<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.bigxperts.com\/sage\/fix-error-sagebi-excelfunctions11xll-dont-match\/#conclusion-%e2%80%93-resolving-%e2%80%9csagebi%e2%80%91excelfunctions11xll-dont-match-sageexe-version%e2%80%9d\" >Conclusion \u2013 Resolving \u201cSageBI\u2011ExcelFunctions11.xll Don\u2019t Match Sage.exe Version\u201d<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.bigxperts.com\/sage\/fix-error-sagebi-excelfunctions11xll-dont-match\/#frequently-asked-questions\" >Frequently Asked Questions<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading block-less-h2\"><span class=\"ez-toc-section\" id=\"causes-of-the-error-sage-biexcelfunctions11xll\"><\/span>Causes of the Error: Sage .BI.ExcelFunctions1.1.xll<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Report designer add-in isn\u2019t installed<\/li>\n\n\n\n<li>Report designer add-in isn\u2019t configured properly in Sage.<\/li>\n\n\n\n<li>Report designer add-in isn\u2019t configured properly in Microsoft Excel.<\/li>\n\n\n\n<li>Other Excel Add-ins are interfering with the reporting process.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading block-less-h2\"><span class=\"ez-toc-section\" id=\"solutions-for-sage-biexcelfunctions11xll%e2%80%9d-dont-match-issue\"><\/span>Solutions for Sage .BI.ExcelFunctions1.1.Xll\u201d Don\u2019t Match Issue&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This error Sage .BI.ExcelFunctions1.1.Xll generally occurs in intelligence reporting when the designer add-in isn&#8217;t configured or installed on the system.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-1-install-report-designer-add-in\"><\/span>Solution 1: Install Report Designer add-in<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The report designer add-in is available for free on Sage\u2019s website. Once you log into your <a href=\"https:\/\/www.bigxperts.com\/sage\/\">Sage support<\/a> portal, you can download the setup file and install the program on your system. If simply installing doesn\u2019t work, then we\u2019ll proceed with the configuration process.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to Sage\u2019s website and log into <strong>Sage Support Portal<\/strong>.<\/li>\n\n\n\n<li>Click on the <strong>Download link <\/strong>for the Report Designed Add-on.<\/li>\n\n\n\n<li>Close all <strong>Sage programs<\/strong>, such as Sage 50.<\/li>\n\n\n\n<li>Go to the <strong>Control Panel <\/strong>and Select <strong>User Account Control<\/strong>.<\/li>\n\n\n\n<li>Click on <strong>Never Notify<\/strong>.<\/li>\n\n\n\n<li>Double-click on the <strong>Report Designer setup file <\/strong>that you downloaded in the previous steps.<\/li>\n\n\n\n<li>Choose a <strong>location <\/strong>on your local storage device to install the report designer add-on.<\/li>\n\n\n\n<li>Follow the <strong>on-screen instructions <\/strong>to install the report designer tool.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-2-configure-the-sage-50-report-designer-add-in\"><\/span>Solution 2: Configure the Sage 50 Report Designer Add-in<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>After installing the add-on on your system, you have to configure it if the error doesn\u2019t resolve automatically. Various add-ins that are already active in Excel can prevent the report designer from properly integrating with Sage 100 intelligence reporting. So first, we\u2019ll fix that problem, and then configure the add-on properly to fix the error permanently.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Launch <strong>Microsoft Excel<\/strong>.<\/li>\n\n\n\n<li>Click on <strong>File<\/strong>, then <strong>Options<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Add-Ins<\/strong>.<\/li>\n\n\n\n<li>Remove <strong>Analysis ToolPak <\/strong>from the Active Application Add-ins.<\/li>\n\n\n\n<li>Remove <strong>Solver Add-In <\/strong>from the Active Application Add-ins.\n<ul class=\"wp-block-list\">\n<li>Go to <strong>Excel Add-ins <\/strong>and choose the add-in that you want to remove.<\/li>\n\n\n\n<li>Click on the <strong>Go <\/strong>button.<\/li>\n\n\n\n<li>Remove the <strong>checkmark <\/strong>against the aforementioned plugins that are causing problems with Excel and Sage intelligence reporting.<\/li>\n\n\n\n<li>Click on ok.<\/li>\n\n\n\n<li>Ensure that the add-ins mentioned are present in the <strong>Inactive Application Add-in<\/strong>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Active Report Designer add-ins <\/strong>with the following steps:\n<ul class=\"wp-block-list\">\n<li>Go to the <strong>Excel Add-ins <\/strong>option from the <strong>Manage <\/strong>option.<\/li>\n\n\n\n<li>Choose <strong>Go<\/strong>.<\/li>\n\n\n\n<li>Mark the <strong>checkbox <\/strong>against <strong>Report Designer Add-in 1.0<\/strong>.<\/li>\n\n\n\n<li>If the Add-in isn&#8217;t listed, then choose <strong>Browse <\/strong>and go to one of the following locations:\n<ul class=\"wp-block-list\">\n<li><strong>On a 64-bit computer <\/strong>&#8211; C:\\Program Files (x86)\\Common Files\\BIExcelFunctions\\32bit\\Sage.BI.ExcelFunctions.xll and click Ok.<\/li>\n\n\n\n<li><strong>On 32-bit computer <\/strong>&#8211; C:\\Program Files\\Common Files\\BIExcelFunctions\\32bit\\Sage.BI.ExcelFunctions.xll<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>When you add the Report Designer Add-In using the browse functions, the option for <strong>Report Designer Add-In 1.0.0 (Custom Task Pane Helper) <\/strong>will appear automatically in the list. You can choose the <strong>Manage <\/strong>drop-down option, then click on <strong>COM Add-ins<\/strong>, and select <strong>Go<\/strong>, if the custom task pane helper isn\u2019t listed by default.<\/li>\n\n\n\n<li>Go back to the Add-ins list and ensure that the Sage intelligence reports are listed on the <strong>Active <\/strong>side of the window.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-3-reinstall-the-report-designer-add-in\"><\/span>Solution 3: Reinstall the report designer add-in<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If the report designer add-in was already present on your system, then you can reinstall the program to fix any damaged files related to the report designer. Once you uninstall the program, you can use the same steps mentioned in the first solution to quickly install the add-in back on your system.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the <strong>Report Manager<\/strong>.<\/li>\n\n\n\n<li>Rename both the folders:\n<ul class=\"wp-block-list\">\n<li>Report Designer Add-in.<\/li>\n\n\n\n<li>Report Designer Add-in consolidation.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Go to <strong>Add and Remove Programs <\/strong>from the <strong>Control Panel<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Sage 100 ERP Intelligence Report Designer Add-in<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Uninstall <\/strong>and follow the on-screen <strong>instructions<\/strong>.<\/li>\n\n\n\n<li>Click on <strong>Finish<\/strong>, then <strong>restart <\/strong>your system.<\/li>\n\n\n\n<li><strong>Reinstall <\/strong>the Sage 100 ERP Intelligence Report Designer Add-in using the steps provided in the sections above.<\/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\/\">Unable to Export to Excel from Sage 50<\/a><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion-%e2%80%93-resolving-%e2%80%9csagebi%e2%80%91excelfunctions11xll-dont-match-sageexe-version%e2%80%9d\"><\/span>Conclusion \u2013 Resolving \u201cSageBI\u2011ExcelFunctions11.xll Don\u2019t Match Sage.exe Version\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This error happens when the Sage Business Intelligence (BI) Excel add-in version doesn\u2019t match the installed Sage.exe version, usually after a software update or version mismatch. Fixing it requires uninstalling the old add-in, clearing residual files, and reinstalling the correct version that aligns with your Sage release. To avoid recurring issues, ensure your Sage BI tools always match your main Sage version. If you&#8217;d rather avoid the hassle, Bigxperts\u2019 <a href=\"https:\/\/www.bigxperts.com\/sage\/errors\/\">sage error support<\/a> team can remotely align your BI add-ins and eliminate the mismatch error, fast and reliably.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-left block-less-h2\"><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-ub-content-toggle wp-block-ub-content-toggle-block\" id=\"ub-content-toggle-block-f153ff5b-efc3-4bfd-8251-7960dee9b872\" data-mobilecollapse=\"true\" data-desktopcollapse=\"true\" data-preventcollapse=\"false\" data-showonlyone=\"false\">\n<div class=\"wp-block-ub-content-toggle-accordion\" style=\"border-color: #f1f1f1; \" id=\"ub-content-toggle-panel-block-\">\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" style=\"background-color: #f1f1f1;\" aria-controls=\"ub-content-toggle-panel-0-f153ff5b-efc3-4bfd-8251-7960dee9b872\" tabindex=\"0\">\n\t\t\t<h4 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-f153ff5b-efc3-4bfd-8251-7960dee9b872\" style=\"color: #000000; \">What does this error indicate?<\/h4>\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\" style=\"color: #000000;\"><span class=\"wp-block-ub-content-toggle-accordion-state-indicator wp-block-ub-chevron-down\"><\/span><\/div>\n\t\t<\/div>\n\t\t\t<div role=\"region\" aria-expanded=\"false\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" id=\"ub-content-toggle-panel-0-f153ff5b-efc3-4bfd-8251-7960dee9b872\">\n\n<p>This error arises when the SageBI\u2011ExcelFunctions11.xll add-in version differs from your installed Sage.exe version, causing compatibility problems between Excel and Sage.<\/p>\n\n<\/div>\n\t\t<\/div>\n\n<div class=\"wp-block-ub-content-toggle-accordion\" style=\"border-color: #f1f1f1; \" id=\"ub-content-toggle-panel-block-\">\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" style=\"background-color: #f1f1f1;\" aria-controls=\"ub-content-toggle-panel-1-f153ff5b-efc3-4bfd-8251-7960dee9b872\" tabindex=\"0\">\n\t\t\t<h4 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-f153ff5b-efc3-4bfd-8251-7960dee9b872\" style=\"color: #000000; \">How do I identify the correct BI add-in version?<\/h4>\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\" style=\"color: #000000;\"><span class=\"wp-block-ub-content-toggle-accordion-state-indicator wp-block-ub-chevron-down\"><\/span><\/div>\n\t\t<\/div>\n\t\t\t<div role=\"region\" aria-expanded=\"false\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" id=\"ub-content-toggle-panel-1-f153ff5b-efc3-4bfd-8251-7960dee9b872\">\n\n<p>Locate your Sage version (e.g., 2023.3) via Help \u2192 About, then download or install the matching BI Excel add-in version from Sage or by contacting your support provider.<\/p>\n\n<\/div>\n\t\t<\/div>\n\n<div class=\"wp-block-ub-content-toggle-accordion\" style=\"border-color: #f1f1f1; \" id=\"ub-content-toggle-panel-block-\">\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" style=\"background-color: #f1f1f1;\" aria-controls=\"ub-content-toggle-panel-2-f153ff5b-efc3-4bfd-8251-7960dee9b872\" tabindex=\"0\">\n\t\t\t<h4 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-f153ff5b-efc3-4bfd-8251-7960dee9b872\" style=\"color: #000000; \">Is there an automated way to fix this?<\/h4>\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\" style=\"color: #000000;\"><span class=\"wp-block-ub-content-toggle-accordion-state-indicator wp-block-ub-chevron-down\"><\/span><\/div>\n\t\t<\/div>\n\t\t\t<div role=\"region\" aria-expanded=\"false\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" id=\"ub-content-toggle-panel-2-f153ff5b-efc3-4bfd-8251-7960dee9b872\">\n\n<p>Some advanced support services offer scripts or automatic tools that detect and reinstall the correct BI add-in version\u2014saving time and avoiding manual file cleanup.<\/p>\n\n<\/div>\n\t\t<\/div>\n\n<div class=\"wp-block-ub-content-toggle-accordion\" style=\"border-color: #f1f1f1; \" id=\"ub-content-toggle-panel-block-\">\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" style=\"background-color: #f1f1f1;\" aria-controls=\"ub-content-toggle-panel-3-f153ff5b-efc3-4bfd-8251-7960dee9b872\" tabindex=\"0\">\n\t\t\t<h4 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-f153ff5b-efc3-4bfd-8251-7960dee9b872\" style=\"color: #000000; \">Who can help fix this issue quickly?<\/h4>\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\" style=\"color: #000000;\"><span class=\"wp-block-ub-content-toggle-accordion-state-indicator wp-block-ub-chevron-down\"><\/span><\/div>\n\t\t<\/div>\n\t\t\t<div role=\"region\" aria-expanded=\"false\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" id=\"ub-content-toggle-panel-3-f153ff5b-efc3-4bfd-8251-7960dee9b872\">\n\n<p>If you need fast, error-free resolution, reach out to <a href=\"https:\/\/www.bigxperts.com\/sage\/\">Bigxperts\u2019 Sage support<\/a> professionals. They\u2019ll remotely align your BI add-in with your Sage install to eliminate the mismatch.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Sage 50 intelligence report requires a report designer add-in to use the Excel functions plugin. If you don\u2019t have the add-in installed with your Sage intelligence reporting, you\u2019ll receive the error &#8220;#NAME&#8221; or &#8220;#NAME?&#8221; displayed in Excel. The error states, \u201cThe file format and extension of \u201cSage.BI.ExcelFunctions1.1.xll&#8221; don\u2019t match. This is specifically because of the&hellip;&nbsp;<a href=\"https:\/\/www.bigxperts.com\/sage\/fix-error-sagebi-excelfunctions11xll-dont-match\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">How to Fix Sage.BI.ExcelFunctions1.1.Xll Don&#8217;t Match File Format Issue<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":87235,"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":[],"class_list":["post-82528","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sage-errors"],"featured_image_src":"https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match.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\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match.jpg",840,300,false],"thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match-150x150.jpg",150,150,true],"medium":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match-300x107.jpg",300,107,true],"medium_large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match-768x274.jpg",768,274,true],"large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match.jpg",840,300,false],"1536x1536":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match.jpg",840,300,false],"2048x2048":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match.jpg",840,300,false],"neve-blog":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match.jpg",840,300,false],"web-stories-poster-portrait":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match-640x300.jpg",640,300,true],"web-stories-publisher-logo":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match-96x96.jpg",96,96,true],"web-stories-thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/10\/Fix-Sage.BI_.ExcelFunctions1.1.Xll-Dont-Match-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":"Sage 50 intelligence report requires a report designer add-in to use the Excel functions plugin. If you don\u2019t have the add-in installed with your Sage intelligence reporting, you\u2019ll receive the error &#8220;#NAME&#8221; or &#8220;#NAME?&#8221; displayed in Excel. The error states, \u201cThe file format and extension of \u201cSage.BI.ExcelFunctions1.1.xll&#8221; don\u2019t match. This is specifically because of the&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/82528","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=82528"}],"version-history":[{"count":2,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/82528\/revisions"}],"predecessor-version":[{"id":87384,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/82528\/revisions\/87384"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media\/87235"}],"wp:attachment":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media?parent=82528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/categories?post=82528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/tags?post=82528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}