Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.