Skip to Content
author's profile photo
Former Member

ERROR while running workbook with macros

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

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo
    Former Member
    Posted on May 06, 2011 at 09:19 AM

    Hi Vikrant,

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

    Good luck.

    Vikram

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 06, 2011 at 10:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded