An Error Occurred While Trying to Generate the Layout - Application-defined or Object-defined Error

The error occurs when trying to run a Sage Intelligence report.

You can try resolving the error by doing the following.

• Opening a blank Excel workbook before running any Sage Intelligence reports
• If the report is not customised report, the Support Team can export report from our side and assist client to import report. 
• Ensuring User Account Control is turned off
• The Add-ins for Sage Intelligence could be missing in Excel or there are other Add-ins for other programs activated that are conflicting with Add-ins for Sage Intelligence. You will need to ensure that only Add-ins for Sage Intelligence are activated
• Enable Macro Settings in Excel
• The Sage Intelligence components could be corrupted and you can uninstall and reinstall Sage Intelligence
• Ensuring you are using 32bit version of Microsoft Office

 NOTE: After trying each solution, check if the report runs or generates before moving to the next solution. 

Opening a blank Excel workbook

Try opening a blank Excel workbook before running any Sage Intelligence reports. In some instances this will resolve the issue.

Export and import the report

The issue could be with the report template. Exporting and importing same report might resolve the issue. You will need to ensure you select Yes on message as below to crate a new template file. You will need to contact our Support Team on [email protected] to get the required reports.

You need to click NO on message as below to create a new container. If there's an issue with the exisiting container the imported report will use new container

Refer to article How do I export and import Sage Intelligence reports into Report Manager?

Ensure the User Account Control (UAC) is turned off

For Sage Pastel to work properly you might need to ensure that the Windows User Account Control or UAC has been turned off as there are background processes that get denied and can lead to error code 20, status 161, Pervasive error code 94 etc.

Refer to article How do I turn off User Account Control?

Add-ins for Sage Intelligence

Ensure the Add-ins for Sage Intelligence are activate. Open Microsoft Excel, click on File, and then select Options.  On Excel Options screen select Add-Ins and check if you have the following Add-ins active. 

Take note of the Type as this the Add-Ins category for each Add-in. You will need this when activating the Add-in

To activate an Excel add-in    

1. Click the File tab, click Options, and then click the Add-Ins category.
2. In the Manage box, click Excel Add-ins, and then click Go.
   The Add-Ins dialog box appears as below.
   
   
3. In the Add-Ins available box, select the check box next to the add-in that you want to activate, and then click OK.

If you cannot find the add-in that you want to activate in the Add-Ins available box, you may need to install it.

To inactivate an Excel add-in    

• Click the File tab, click Options, and then click the Add-Ins category.
• In the Manage box, click Excel Add-ins, and then click Go.
• In the Add-Ins available box, clear the check box next to the add-in that you want to inactivate, and then click OK.

In many cases, when you inactivate an add-in, it is removed from its group on the ribbon. In other cases, to remove the add-in from the ribbon, you may need to restart Excel.

Note  Inactivating an add-in does not remove the add-in from your computer. To remove the add-in from your computer, you must uninstall it.

Enable Macro Settings in Excel

Open Microsoft Excel, click on File, and then select Trust Center and then click on the button Trust Center Settings. Click on Macro settings and select the option Enable VBA macros or Enable all macros as shown below.

Uninstall and reinstall Sage Intelligence

The Sage Intelligence components could be corrupted and you can uninstall and reinstall Sage Intelligence. Follow the steps below to

Uninstall Sage Intelligence

• Navigate to your Control Panel
• Select Programs and Features
• Highlight Sage Intelligence (Ensure you have selected the correct version i.e. V19)
• Select uninstall and the top of the window
• Navigate to C:\Program Files (x86)\Common Files
• Rename the following files to OLD
  • BIComponents
  • BIComponentsDotNet
  • BIExcelFunctions1.1
  • BIGenerator

Reinstall Sage Intelligence

• Click Here to download the latest version of Sage Intelligence
• Select the Accounting Cross Sell product tab
• Select the correct Sage Intelligence download i.e. Partner or Xpress depending on which product you are running
• Once downloaded run the installation

Refer to article How do I install Sage Intelligence?

Ensuring you are using 32-bit version of Microsoft Office

You check by going to File...Account and About Excel. The bit version will show as per example below.

If the machine with issue is using 64-bit version of Microsoft Office, you can try uninstalling this and installing 32bit version of Microsoft Office. 

 CAUTION: Please note that you will need your IT Personnel to assist with the installing of Microsoft Office.