Skip to Content
avatar image
Former Member

Problem in BPC 7.0 Excel -> eData

Hello everybody,

I have the local problem on my computer with the bpc for excel client. When I open BPC Excel and open the eData Menu then bpc loads something from the bpc system and later my excel showa me the following error message: "An error occurred while adding excel menus. Object variable or with block variable not set."

I have uninstalled my bpc office an reinstalled it. I have deleted my bpc-program-folder and my "documents/bpc"-folder but the error still exists.

Has anybody an answer?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 22, 2010 at 08:57 AM

    Hi,

    Just enable the excel macro this will solve the issue. You can do that from excel option-->Trust Center.

    Regards

    Raman

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Radharaman Singh Rajkumar

      Sorry, but this option is blocked in our company. A few days before I have used bpc without setting this option. Is there a workaround available?

  • avatar image
    Former Member
    Sep 23, 2010 at 12:11 PM

    Hello,

    I have the same problem with SAP BPC 7.5 SP4

    When I click "Manage data" in interface for Excel, I get an error "An error occurred while adding Excel menus". Then Action Pane opens Manage Data Options. But when I click for example on "Upload data files" I get "object variable or with block variable not set " with head of diallog "ev4clientDataMgr".

    In Excel Trust Center I enable all macros and trust access to VBA.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Daniel Jacinto

      Hi Daniel:

      Thanks for the answer, i still have some doubts:

      1. How toreset the COM+ OsoftDMServer? On the .net server right?

      2. What is the usage of Xceedzip.dll ?

      regards

      jav