Unable to get the Add property of Workbooks class

From Sage Intelligence Knowledgebase
Jump to: navigation, search

ISSUE: UNABLE TO GET THE ADD PROPERTY OF THE WORKBOOK CLASS


SYMPTOMS:

When running out report the error “Unable to get the Add property of the Workbook class” displays


CAUSE:

Microsoft Excel seeing some XLT files created in earlier versions as an invalid file format.


RESOLUTION/WORKAROUND:

Download the tool FixTemplates.exe from here (copy the link to a browser window):

http://www.alchemex.org/SoftwareDownloads/Tools/FixTemplates.zip

Place it in the folder that contains the report template XLT files.

Run the tool and press the “Run Repair” button to allow it to check each XLT for the file format incompatibility and then to repair it.

When prompted to repair each book press Yes.


APPLIES TO:

All Alchemex products