Unable to open BEx analyzer

[Former Member]

Hi all,

I'm getting following error when opening BEx analyzer:

This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error039760_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Program Files\Common Files\SAP Shared\BW\sapbex.xla'</summary>

- <additionalInfo>

<info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info>

</additionalInfo>

</recoveryLog>

Thanks,

Deepika

[Former Member]

install the latest patch for BEx. it is avaiable in the service market place.

HOpe this would help you.

[michael_devine]

Hello,

BEx Analyzer is a Macro, which sits on Microsoft Excel is a VBA Project. This issue seems that you have no VBA installed or active.

Read the Microsoft Office documentation below:

http://support.microsoft.com/kb/282847

http://support.microsoft.com/kb/287567

Uninstall the Microsoft office version from this client and reinstall it again. Then make sure that this time you are able to access Visual Basic for Applications (VBA) for Microsoft Excel.

Thanks,

Michael