Error in HYPERLINK function

Christian Caiumi 0 Reputation points
2023-11-28T13:51:20.6566667+00:00

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

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,332 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Christian Caiumi 0 Reputation points
    2023-11-29T07:57:57.86+00:00

    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

    0 comments No comments

  2. Emi Zhang-MSFT 23,811 Reputation points Microsoft Vendor
    2023-11-29T08:31:34.72+00:00

    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.

    0 comments No comments

  3. Christian Caiumi 0 Reputation points
    2023-11-29T10:12:12.4866667+00:00

    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


  4. Christian Caiumi 0 Reputation points
    2023-12-01T09:05:14.6466667+00:00

    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!

    0 comments No comments