I cannot remove the 'ctrl and click option for hyperlink - I JUST want to click on the cell and automatically open the hyperlink.

Anonymous
2024-04-14T12:52:10+00:00

I have a document I share using Excel online via onedrive. I update it in on the desktop app and people access it via a link, and view it on the Web version.

Up until yesterday, a viewer would be able to click a cells with a hyperlink to another sheet in the workbook, and it would automatically take them there. Today, every single cell with a hyperlink requests the viewer to 'ctrl and click' to follow the hyperlink.

I have gone though every single option on my desktop Excel app to try and turn off this 'ctrl and click' functuon but I genuinely cannot find anything relevant or that has worked. I have the latest version of Excel for Mac and I haven't changed any settings.

Please, how do I make hyperlinks work automatically again? Thank you!!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2024-06-04T14:21:42+00:00

I found that hovering over the link pops up the link. Click it and the tab opens as the active tab.

Was this answer helpful?

5 people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2024-06-04T14:14:21+00:00

I Found a work around, select Cell / right click mouse / link options /open link

Was this answer helpful?

3 people found this answer helpful.
0 comments

61 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-06-02T16:49:09+00:00

    I have the same problem but when you have nothing but touchscreen monitors on the production floor it is hard to ctrl tap to get to the document they need. Its frustrating as some work and some don't and I am not sure if it is a permission issue or just how updates are rolled out. Either way, it would be great if I could turn off the ctrl click but since it doesn't allow me to make those changes on M365 excel online it does me no good.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2024-05-31T09:39:35+00:00

    I know its not a solve but if you hover over the linked cell the link appears and you can click on it to open in a new tab

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2024-05-29T19:00:34+00:00

    I gave a Microsoft help desk person remote access to my laptop and OneDrive today and re-created the problem to help them understand.

    Nice person and she tried a few things but I don’t think she was able to offer much in the way of a solution, she said she would ask her technical team to look at it and wanted to close the help request as resolved, I insisted she leave it open and unresolved.

    Later I received an advice email suggesting I look at an irrelevant post from 2019 and the following:

    If you prefer here's some-help resources:

    • Microsoft Support: provides self-help instructions for common customer questions.
    • Microsoft Community: provides answers to questions others have asked (yours might be the same), or you can ask a new one for free. If you're new to Community, click Get more info for information on how to search for a solution or ask a question.

    So, we’re no closer to getting this resolved.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments