EPM PATH LINK

[muthukrishnan]

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

[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.....

[muthukrishnan]

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

[johannes_knaub4]

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

[former_member186338]

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

[Former Member]

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

[muthukrishnan]

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

[former_member186338]

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

[muthukrishnan]

Here used 2 sub. Name is Save and Refresh.

It's triggered thru button.

[former_member186338]

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

And nothing like Workbook_Open()?

[muthukrishnan]

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

[former_member186338]

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