Skip to Content
avatar image
Former Member

EPM General Error

Hello Experts,

I am working on building a multi-sheet workbook within Excel using the EPM Add-in for BPC.  My main sheet is working fine.  I built a simple input form on another sheet, and when I try to Save Data, I get the Following error:

EPM General Error: Invoke or BeginInvoke cannot be called on a control until the window handle has been created.

The main sheet does have a good amount of code and macros just fyi.  I do now know what it means and was unable to find a result online.  Anyone have a way to resolve this?

Thanks,

Sean

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 02, 2013 at 10:13 AM

    Hi Sean,

    try by clicking on "Clear Metadata Cache" button.

    Kind regards

         Roberto

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks everyone for the input.  I discovered the issue was happening when I tried to Save data from Sheet 2 and it was running the code applied to Sheet 1.  I fixed it by adding a statement to Exit the Function if the Active sheet was sheet 2.  It appears to be working fine now.  Thanks again for your input.

  • Jun 29, 2013 at 12:01 AM

    Sean,

         Their is a alot stability related issues with EPM v10 prior to SP13.   I would very recommend using Office 2010 with EPM v10 + SP13 or better for stability.

    Regards,

    Ajay

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Ajay,  I am on Office 2010, v10 SP 13.  When I first logged in this morning, the error did not appear when I first testing saving data.  It just popped again when tryign to submit on Sheet 2, and now nothing will submit, so It appears to be something around the second sheet.  Thanks for the input.

  • avatar image
    Former Member
    Jun 28, 2013 at 07:31 PM

    Hi Sean

    When you create new sheet (main sheet not open) does it work ok ?

    If yes check what is written in VBA macro under event save_data in main sheet.

    Jack

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 24, 2013 at 07:06 AM

    Dear Friends..!

    I m on EPM SP 14 ,

    While working on EPM Excel ,Trying

    1. Open--> Open server root folder and Selecting the report format .

    2. Displaying Format Report Structure Fields.

    3. In the Report Fields given Data and trying "Save data" , ICON

    I would like to Manually load the data in fields and  need to store those fields (Data) .


    Immediately throwing  "There is no data to save  " .

    So Pl can guide for me how to over come this Issue.


    Regards

    Sasi

    Add comment
    10|10000 characters needed characters exceeded