Hyperlink in TM1 Web

[TimeTq]

Hi, I want to create a hyperlink from xlsm file to another xlsm file ( both of them on server).

I tried with a TM1://ServerName/blob/PUBLIC/.\}externals\filename.xlsm. Name of the file i got from filename.blob file (ENTRYREFERENCE) in an }application folder. After I click on hyperlink i got "Failed to open destination workbook. Make sure the file has not been renamed or deleted."

Does someone know how to fix it?

[Mark RMBC]

HI,

You need to use the name of the file in the externals folder, not the applications.

Also, I have found that if I try to hyperlink from excel and then publish the form to the application folder it fails. So I just create the hyperlink, don't test it in excel and then publish it. Then test it on the web.

regards,
mark

[TimeTq]

Hi, there is .blob file in application folder. If you open it with notepad, you'll find a name of file same as in externals folder (ENTRYREFERENCE).

I made a working hyperlink but on .xlsx file from .xlsx file. Is there problem with xlsm files?

[orlando]

Hi, I want to create a hyperlink from xlsm file to another xlsm file ( both of them on server).

Hi,

out of pure curiosity - why are you not using an "action button"?

best regards
orlando

[Wim Gielis]

Hi, I want to create a hyperlink from xlsm file to another xlsm file ( both of them on server).

Hi,

out of pure curiosity - why are you not using an "action button"?

best regards
orlando

True, if wanted, the button formatted as a hyperlink.

[Mark RMBC]

Yes I was wondering about the Action Button too.

But for information, I can hyperlink to a .xlsm too