ERROR while running workbook with macros

[Former Member]

Hi all

I am running a workbook which has macros in it and thus some buttons for different functions.

Whenever i click on a particular button which should give a new selection window, it is giving me an error as follows:-

" Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience."

Please help me out to resolve this issue.

Any help would be grateful.

Thanks,

Vikrant Mahajan

[Former Member]

Hi Vikrant,

You can check any of the below options. Hope it helps :

- Check if you have not opened any other excel in the background .

- Check Excel security settings and Macros settings via Office Button -> Excel Options -> Trust Center ->

Trust Center Settings-> Macro Settings

- Also try installing updated version of the MSExcel 2007 BI ADD-ON Patch and enable tha Macros.

- Update GUI patch.

Regards,

Akanksha

[Former Member]

Hi Vikrant,

Try upgrading GUI patch and BW Front End patch to the latest. This should resolve the issue.

Good luck.

Vikram