Skip to Content

EPMLink functionality

Hi Everyone,

I have been trying to get the EPMLink funcion working. I have install EPM-Addin_40NET SP12 Patch 4. (this was supposed to fix certain things in it.) However, when I create it in a simple workbook. =EPMLink("DEV - Finance - BPC","SCENARIO_ANALYSIS.xlsx","Test Report") I get the following error:

Workbook does not exist: C:\Documents and Settings\Administrator\My Documents\PC_NW\Administrator\AppInfo\BPC\FINANCE\eEXCEL\Reports\Wizard\SCENARIO_ANALYSIS.xlsx

What I need to know is can the EPMLink funciton open a spreadsheet on the server (looks like it can't). Why does it open it from Reports\wizard folder?

Note 1754437 suggests there is a new funciont in SP12 patch 4, I can;t find that there. It also suggests you can open files from the server. This doesn not seem to be the case.

Does anyone have any other info on this functionality. The old EvHot funciton was frustrating that it could not open files from the server. I was really hoping that this had been resolved.

thanks so much.


Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Sep 14, 2012 at 10:44 AM

    Hello Tim,

    Try the EPMExecuteApi function instead (used to be EVMNU):

    =EPMExecuteApi("OpenSpecificDocument","Test report","REPORTS\SCENARIO_ANALYSIS.xlsx","Company")

    This should do the trick.

    Hope this helps,


    Message was edited by: Eric Hammer You also need to activate the "FPMXLclient" reference in the VBA editor, otherwise the function will fail to execute.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Eric,

      Sorry, got distracted. I got the EPMLink function working. (so I can opena report and set current view). The SP12 patch 4 EPM addin seemed to work, but I found that if the directory was not the same as the server, it defaulted to the local desktop. There is a new funciton called EPMLinkPath, but I am not sure exactly the differece.