"Error" Unable to get the Add property of Workbooks class

From Sage Intelligence Knowledgebase
Jump to: navigation, search

"Error" Unable to get the Add property of Workbooks class Article

Products

Sage 100 Contractor


Sage 100 ERP


Sage 300 ERP


Sage ERP X3


Sage Intelligence


Sage 500 ERP


Description

You get an error when trying to run any of the dashboard reports using Excel 2007.

The error message is: "Unable to get the Add property of Workbooks class".



Cause

The issue is caused by Excel 2007 not recognizing the xltm template.


Resolution

1. Navigate to the Sage Intelligence templates folder. You will find the location in the Report Manager under the Template Storage Location field.

2. Open the Dashboard Analysis AR 3-8 Report in Excel.

3. Click on Save.

4. Click on the drop down option under Save as Type.

5. Select Excel Macro-Enabled Template (*.xltm).

6. Click on Yes.

7. Click on Save.

8. Select the location, you can save it on your desktop for the time being. Ensure that it' s the same name as the original report.

9. Copy the report from your desktop and paste it to the original location found in step 1. Replace the current report.

10. Rerun the report from the Report Manager.



Category

Configuration


Customization


Entitlement

Open


Defect ID


8004387717 alchemex 26819

Last Modified Date:6-17-2015ID:64541