$(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
0

EPM PATH LINK

Feb 17, 2017 at 09:34 AM

209

avatar image
Former Member

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

10 |10000 characters needed characters left 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.....

0
* Please Login or Register to Answer, Follow or Comment.

5 Answers

avatar image
Former Member Feb 17, 2017 at 10:40 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

What is the Sub name? How it's triggered?

0
avatar image
Former Member Feb 17, 2017 at 10:49 AM
0

Here used 2 sub. Name is Save and Refresh.

It's triggered thru button.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

And you don't have macro with the name AFTER_WORKBOOK_OPEN?

And nothing like Workbook_Open()?

0
avatar image
Former Member Feb 17, 2017 at 11:21 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

The mentioned macros will be triggered when workbook is opened, incorrect code in this macros can result in errors...

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

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 19, 2017 at 05:01 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Munthu,

did you solve the issue.

we updated from SP22 to SP29/SP30 and are having the same issue.

Link results in an error "Quick Link Exception".

Afterwards a refresh works fine

0

Please post a new question with full description of your issue!

0