Table of Contents

KB Item 83

Product

SAP BUSINESS ONE

Product Version (if applicable)

None Defined

Issue

XL Reporter Error starting Excel! Cause (Open Workbook) Method ``` of object ```

Symptom

Error starting Excel from XL Reporter

Cause

Trust Center settings

Resolution Notes

The Excel security settings are as follows:- Active X – Enable all controls without restrictions… etc, Safe Mode ticked Macro – Enable all macros, trust access to VBA ticked Add-ins – SAP Business One XL Reporter is shown in the list and Ticked as available under Com Add-Ins. Load Behaviour: Load on Demand, (not currently loaded)

In Excel 2010 , go to File > Options >Trust Center > Trust Center Settings > Protected View, Under the Data Execution Prevention option uncheck the “Enable Data Execution Prevention mode”.

KB Type

Solution

Item Date

21 Feb 2012