Skip to Content
avatar image
Former Member

EPMPathLink

Hello,

I have been trying to get the EPMPathLink funcion working. I have install EPM-Addin_40NET SP19 .

However, when I create it in a simple workbook. =EPMPathLink(, "INPUT\IS_INSERT.xlsm", "INSERT",EPMMemberID(J64),EPMMemberID(K64),EPMMemberID(L64),EPMMemberID($K$27),"[category].[].["&$M$27&"]",$O$27).

I get the following error:

"Workbook is already opened."

Does anyone have any other info on this functionality.

Best Regards,

Deepak

Capture.PNG (47.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 04, 2015 at 05:06 PM

    Hi Deepak,

    You are getting error because of your IS_INSERT.xlsm is already open.  Please close template and try again. whenever you are using this function confirm that linked report should not open.

    Regards,

    Sushant

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Deepak,

      Just try in new excel file and then hard code the members use unique name of id's that you have used for category dimension and try it again.

      As i mentioned in earlier post follow same procedure. Use same path for time being that used in the screen shot, after confirmation of linked templates gets open.Then try for the different path and different template. while running close all other excels only working excel should be open.

      Regards,

      Sushant

  • Jan 05, 2015 at 05:45 AM

    Hi Deepak,

    Create simple template without VBA code and try to reproduce this error.

    Follow the all steps as suggested by Sushant.

    Shrikant

    Add comment
    10|10000 characters needed characters exceeded