This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 44%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Hi everybody, i have a problem with the HYPERLINK function in my Microsoft 365.
The function works well linking other types of files (for example pdf's and so on), otherwise links to other Excel files or other positions into the same Excel file do not work. When i click on the link created by the function, appears the message "impossible to open the selected file".
I have this problem also in an Excel 2019 copy i have in another computer.
Any suggestion about it?
Thank you very much!
Chris
Hi,
Could you provide a sample about the formula in table?
I created a formula in Sheet 1, that links to the cell B3 in Sheet 2:
=COLLEG.IPERTESTUALE('Sheet 2'!B3;"My english Friend")
But the link doesn't work.
My Excel version is in italian, in english the name of the function is HYPERLINK, and works in the same way.
Unfortunately i can not attach an Excel file
Hi,
I'm using English language Office, I suggest you try this formula:
=HYPERLINK(CELL("address",Sheet2!B3),"My english Friend")
You can translate the formula to Italian manually, hope the information is helpful.
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi Emi, first of all, thank you for your advice. The formula you suggested is theoretically working, but the link is not established (appears the usual message "not possible to open the specified file"). I don't think it's a problem of the formula, but a block of the link
Because you have opened the specific file, you cannot open the same file twice at the same time.
My formula is to help you jump to the desired cell position.
Hi Emi, today i tried to use the function once more, remembering to close the address of the linked file into "", and it worked... In all situations: to external excel files, to a cell in the same file... I don't know why, but now it works correctly. Maybe i forgot to close the address into "".
I'll make some other proves to confirm all.
Thank you very much for your assistence!