Epmlink doesnt work

[Former Member]

Hello, I am trying to link to some reports that are on the server. I have tried to follow the route mentioned in manual, and also couple of other options discussed in forums previously. However I cant get it to work. what exactly is the route that I need to specify...e.g. webfolders/reports/report.xlsx ?

thanks.

[former_member186338]

The file has to be located in \WEBEXCEL\TEMPLATELIBRARY\REPORTS\WIZARD\ - root folder for EPMLink

And this file will be opened with:

=EPMLink(;"samp.xlsx";"Test")

You can create folder under WIZARD like F1 then the formula will be

=EPMLink(;"F1\samp.xlsx";"Test")

Vadim

[Former Member]

If I put it in wizard folder I can access it just fine, is there any way to make it work with other folders?

[former_member186338]

Only for folders under WIZARD folder!

[Former Member]

How about using epmpathlink? will that do? on a side note, Is there a way to put PDF files in that folder? I am able to upload pdf using UJFS but when I double click on it it tries to open in excel.

[Former Member]

Quick update - I was able to accomplish linking to other folders(other than wizard) by using epmpathlink.

[former_member186338]

Yes, it's clearly stated in help - for epmpathlink the root folder is: \WEBEXCEL\TEMPLATELIBRARY\

But both functions are designed to open Excel files!

You can play with =EPMDocument...

Vadim

[Former Member]

Hi Manny,

Where is the workbook?

Use something like this:

\WEBEXCEL\TEMPLATELIBRARY\REPORTS\WIZARD\

Also make sure that double-click actions are enabled (the Enable Double-Click option must be selected in EPM -> Options -> User Options).

Andy