Can you link to a specific sheet within an XLS workbook stored on LL?

[anymouse]

Is it possible to link to a specific worksheet of an Excel workbook that is stored on a Livelink server?

For an Excel workbook stored on a Windows file system, you can create a hyperlink to a specific worksheet within that workbook by using a link such as: file://C:/Workbook.xls#Sheet3!A1.

If the Excel workbook is stored on a web server, a similar format can be used:

http://www.mycompany.com/Workbook.xls#Sheet3!A1

On our Livelink server, I have tried many different variations of

http://livelink.mycompany.com/Livelink.exe/open/123456789#Sheet3!A1

(where 123456789 is the Livelink number that points to the worksheet) but none have worked.

 

[ggriffit]

not tried this myself, but there are a few posts in the KC on this including :

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=17014538&objAction=view&show=2

and

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=17034487&objAction=view

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[clbr]

Two thoughts on this:
1)You might try using the WebDAV url like:

http://livelink.mycompany.com/livelinkdav/nodes/123456789/myexclefile.xlsx#sheet3!A1

I generally recommend trying webdav for things that MS Office does natively, if the regular url doesn't work.
2) If you don't have SSO or NTLM authentication and your Livelink will prompt for a username and password, then Excel is probably just getting the html of that login page when you access the link.