Bex Analyser issue

[Former Member]

Dear Experts,

I have this strange problem for some of my Users where when they are trying to open Bex Analyser with Tcode RRMX in BW system they get an errror message saying.

Pop up appears.popup Microsoft Visual Basic.

in the popup message says " Runtime Error 91"

object variable or with block variable not set" and the options given are end,debug,help tabs.

Can any one please advise me what could be the problem.

I think this is not a authorisation problem or could it be.

Please advise.

Thanks,

Tati

[Former Member · Accepted solution]

Hi,

If you are using Excel 2010 , please refer to the following note for this runtime error.

1468414 Runtime error when using BExAnalyzer in Excel 2010

Please makse sure that you have applied the Latest Patch for your Bex Frontend GUI.

Regards,

Amit

[Former Member · Accepted solution]

Thanks all for responding, But this issue is for only certain users who are in France where as I am able to acess BEx analyser normally without any error.

In this case what would be the reason, Our users login via citrix for acess BEx analyser.

Thanks,

Tati

[Former Member]

Hi,

How did you solve this issue?

Thanks

[former_member188080]

Hi,

Check following thread as well

Thanks and regards

Kiran

[Former Member]

I think this issue is related to MS office excel .can you go the Microsoft excel than to tool and macro then to security and keep the setting as medium..

I guess this will work for you

Thanks

Raja

[Former Member]

Hi,

Please check whether the latest Patch is installed on the PC where your user from France are logging in via Citrix.

Also you need to check which Excel version is available on that particular PC.

You should also check out the notes which are provided to you.

Regards,

Amit

[arvind_doomra]

Dear Tati,

This is a known issue and will be resolved with below SAP Note:

1581228 BExAnalyzer : VBA error 'Project or library can not found'

also make sure that you have latest frontend patch 5 installed from service market place.,

Regards,

Arvind

[former_member225306]

Hi,

Please refer the below note and this should resolve the issue.

1533608 Collective note for RRMX issues

Thanks,

Venkat