Skip to Content
author's profile photo
Former Member

Error with XLReporter in Excel2007.

Hi there,

Need assistance with XLReporter in Windows 7 Pro (64bit) running MSOffice 2007.

Get the following error when running report:

error starting Excel! Cause (Open workbook) method '~' of object.

I've seen a suggested fix meant for Office 2010 (as seen below), but can't find the same options in Excel 2007.

Office 2010 fix:

In Excel 2010 , goto File, Options, Trust Center, Trust Center Settings, Protected View, Under the Data Execution Prevention option, untick the "Enable Data Execution Prevention mode".

Please help.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • author's profile photo
    Former Member
    Posted on Apr 12, 2011 at 08:58 PM

    Hi,

    It is under bottom line of Office button called Excel Options. You can find Trust Center there.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 13, 2011 at 06:12 AM

    Hi GordonDu,

    I know how to get to the trust Centre Settings, but from there I can't seem to find anything related to "Protected View" or "Data Execution prevention".

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      This is newly added security setting. It is not there in 2007. You just need to check if Macro setting has Enable ALL and Trust VB checked.

  • author's profile photo
    Former Member
    Posted on Apr 14, 2011 at 06:11 AM

    I already have Macros enabled and trust VB checked.

    I uninstalled/reinstalled the SAP client completely and also ran a repair on the OFF2007 installation + downloaded all the latest MSUpdates, but to no avail......the problem remains.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 14, 2011 at 12:57 PM

    Have you tried turn off UAC?

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 14, 2011 at 01:03 PM

    Yes, UAC is already turned off.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I had a look at Note 918188 and replaced the 'excel.exe.config' file, but now I get the error below:

      An error occurred the process u201CIFDSLib Initializeu201D.

      Description: (666) Internal error while processing license-key!

      File or assermbly name Blowfish_NET, or one of itu2019s dependencies, was not found.

      XL Reporter startup failed!

      I've uninstalled the sap client again completely, deleted the C:\Programfiles\SAP folder, and also deleted all the entries starting with 'ix...' in the registry. Then I reinstalled the SAP client from scratch again. This also did not resolve the problem.