TM1 Forum

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?

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

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?

TimeTq wrote: ↑Tue Feb 25, 2020 10:07 am 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

orlando wrote: ↑Wed Feb 26, 2020 10:57 am

TimeTq wrote: ↑Tue Feb 25, 2020 10:07 am 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.

Yes I was wondering about the Action Button too.

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