$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content

EPM PATH LINK

quick-link-exception.jpgHi Experts,

When i am moving from one file to another file using EPMlink formula, i am getting 'Error in the refresh sheet". I have used EPM add-in version 10 SP26.

Formula: =EPMLink("CONSOL","EPM10/Input Schedules/Movement/All_Movements.xltm","Movement Input")

Regards,

Muthu

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Hi Muthu,

    Please specify correctly if you are using EPMLink function or EPMPathLink function! Header says PathLink and formula EPMLink. Also please specify what macro are you using in the input schedule?

    Looks like formula is working fine.....

  • Get RSS Feed

5 Answers

  • Feb 17, 2017 at 10:40 AM

    Hi Priyanka,

    I have used epmlink function and used save and refresh macros.

    Macro:

    option Explicit

    Dim client As New EPMAddInAutomation

    Dim EPMOBJECT As New FPMXLClient.EPMAddInAutomation

    Sub Save()

    client.SaveAndRefreshWorkbookData

    End Sub

    Sub Refresh()

    EPMOBJECT.RefreshActiveWorkBook

    End Sub

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 17, 2017 at 10:49 AM

    Here used 2 sub. Name is Save and Refresh.

    It's triggered thru button.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 17, 2017 at 11:21 AM

    No. I have not used anything like that.. If need?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2017 at 12:02 PM

    Are you getting any error when you individaully open the input schedule from the server?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 19, 2017 at 05:01 PM

    No Priyanka. Also, i changed epm addin version 10 SP24. It's working fine. But SP26 version getting this pblm.

    Add comment
    10|10000 characters needed characters exceeded