Fix Sage error “The file format and extension of “Sage .BI.ExcelFunctions1.1.all” don’t match

Sage Intelligence report requires a report designer add-in to use the excel functions plugin. If you don’t have the add-in installed with your Sage intelligence reporting, then you’ll receive the error “#NAME” or “#NAME?” displays in Excel when running a Report Designer Add-In report in Sage 100 Intelligence.” The error also states that “The file format and extension of “Sage .BI.ExcelFunctions1.1.all don’t match”. This is specifically because of the missing designer add-on. Fixing the error requires you to install the report designer, and then configure Microsoft Excel so that both programs can work together without creating conflicts that lead to errors.

In this post, you’ll learn how to fix the Sage error “The file format and extension of “Sage .BI.ExcelFunctions1.1.all” don’t match.

Error: “#NAME” or “#NAME?” displays in Excel when running a Report Designer Add-In report in Sage 100 Intelligence.

Causes of error “The file format and extension of “Sage .BI.ExcelFunctions1.1.all” don’t match:

• Report designer add-in isn’t installed
• Report designer add-in isn’t configured properly in Sage 100.
• Report designer add-in isn’t configured properly in Microsoft Excel.
• Other Excel Add-ins are interfering with the reporting process.

Solutions for “The file format and extension of “Sage .BI.ExcelFunctions1.1.all” don’t match 

This error generally occurs in Sage 100 intelligence reporting when the designer add-in isn’t configured or installed on the system. Because we know the exact causes of this error, it becomes daily simple to fix this error.

Let’s get started with the process.

Solution #1: install Report Designer add-in

The report designer add-in is available for free on Sage’s website. Once you log into your Sage support portal, you can download the setup file and install the program on your system. If simply installing doesn’t work, then we’ll proceed with the configuration process.

Steps to install report designer add-on in sage:

1. Go to Sage’s website and log into Sage Support Portal.
2. Click on the Download link for Report Designed Add-on.
3. Close all Sage programs, such as Sage 50 and Sage 100.
4. Go to the Control Panel and Select User Account Control.
5. Click on Never Notify.
6. Double click on the Report Designer setup file that you downloaded in the previous steps.
7. Choose a location on your local storage device to install the report designer add-on.
8. Follow the on-screen instructions to install the report designer tool.

If you couldn’t find the options to disable user account control settings in Windows, then here’s an expanded list of step by step instructions to make things easier for you.

Steps to change User Account Settings in Windows 10:

1. Press Windows + R together to launch the Run command.
2. Type in the Control Panel, then hit Enter.
3. Click on User Accounts.
4. Choose User Accounts (Classic View).
5. Click on Change user account control settings.
   Note: choose Yes if UAC prompts you to confirm that you want to change the settings for a user account.
6. Move the slider to Never Notify and choose Ok to turn off UAC for the user account that you’re currently logged into.
7. Restart your system.

Solution #2: configure the Sage Report Designer Add-in

After installing the add-on on your system, you have to configure it if the error doesn’t 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’ll fix that problem, and then configure the add-on properly to fix the error permanently.

Steps to configure the designer tool and Microsoft Excel to fix the file format error in Sage:

1. Launch Microsoft Excel.
2. Click on File, then Options.
3. Choose Add-Ins.
4. Remove Analysis ToolPak from the Active Application Add-ins.
5. Remove Solver Add-In from the Active Application Add-ins.
   1. Go to Excel Add-ins and choose the add-in that you want to remove.
   2. Click on the Go button.
   3. Remove the checkmark against the aforementioned plugins that are causing problems with excel and Sage intelligence reporting.
   4. Click on ok.
   5. Ensure that the add-ins mentioned are present in the Inactive Application Add-in.
6. Active Report Designer add-ins with the following steps:
   1. Go to the Excel Add-ins option from the Manage option.
   2. Choose Go.
   3. Mark the checkbox against Report Designer Add-in 1.0.
   4. If the Add-in isn’t listed, then choose Browse and go to one of the following locations:
      1. On a 64-bit computer – C:\Program Files (x86)\Common Files\BIExcelFunctions\32bit\Sage.BI.ExcelFunctions.xll and click Ok.
      2. On 32-bit computer – C:\Program Files\Common Files\BIExcelFunctions\32bit\Sage.BI.ExcelFunctions.xll
   5. When you add the Report Designer Add-in using the browse functions, the option for Report Designer Add-In 1.0.0 (Custom Task Pane Helper) will appear automatically in the list. You can choose the Manage drop down option, then click on COM Add-ins, and select Go, if the custom task pane helper isn’t listed by default.
   6. Go back to the Add-ins list and ensure that the Sage intelligence reports are listed on the Active side of the window.

Solution #3: Reinstall the report designer add-in

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.

Steps to repair and reinstall Sage Report Designer on your PC:

1. Go to the Report Manager.
2. Rename both the folders:
   1. Report Designer Add-in.
   2. Report Designer Add-in consolidation.
3. Go to Add and Remove Programs from the Control Panel.
4. Choose Sage 100 ERP Intelligence Report Designer Add-in.
5. Choose Uninstall and follow the on-screen instructions.
6. Click on Finish, then restart your system.
7. Reinstall the Sage 100 ERP Intelligence Report Designer Add-in using the steps provided in the sections above.

Some Additional Solutions to Resolve “The file format and extension of “Sage .BI.ExcelFunctions1.1.all” don’t match 

method 1:

• Go to C:\Program Files(x86) Common Files\BI Generator OR C:\Program Files\Common Files\BI Generator on 32-bit machines
• Run the AlchemexPolicy.exe as the administrator

Method 2:

• Open the command prompt as an administrator.
• On 32-bit machines, you would type cd C:\Program Files(x86)\Common Files\BIGenerator or C:\Program Files\Common Files\BIGenerator.
• You need to enter the following command line A1chemexPolicy.exe mention “Excel” and Enter. This will register the A1chemex application.

Conclusion

So this was our guide on how to fix Sage error “The file format and extension of “Sage .BI.ExcelFunctions1.1.all” don’t match. I hope that you found it helpful in fixing the error related to this program. And if you have any other concerns, then feel free to reach out to our experts.

---

FAQ

---