General discussion

  • Creator
    Topic
  • #2258941

    Hyperlinks in Shared Excel Workbooks/Spreadsheets

    Locked

    by wattsnew ·

    Hello,
    I was told that you cannot insert or create a hyperlink in an Excel file that you have saved as a shared workbook. Is this true? And does anyone out there know of an alternate way of inserting the hyperlink?

All Comments

  • Author
    Replies
    • #3214518

      Workaround

      by dugadugdug ·

      In reply to Hyperlinks in Shared Excel Workbooks/Spreadsheets

      Not sure of alternatives but what you can do to insert hyperlinks is to remove the sharing, insert the hyperlink you want and then reshare the workbook.

    • #2846095

      Woohoo!

      by bdaragon ·

      In reply to Hyperlinks in Shared Excel Workbooks/Spreadsheets

      Excellent, I was playing around with few different options for some time already, this really helped, Thanks.

    • #2883548

      pdf hyperlink dont open

      by mrsalaa ·

      In reply to Hyperlinks in Shared Excel Workbooks/Spreadsheets

      Hello,
      I’m acing serious issue inPdf hyperlinks.
      when i try to hyperlink a gpeg file or an e mail adress or mp3 to a working doc (word or exce) they perfectly work. but whn i try to hyperlink a pdf they never open and the excel and word program give me error message says : some files can contain virusus or otherwise harmful be harmful to your computer. it is importnat to be certin that this file is from trustworthy source, would you like to open this file?.
      and when i click yes, becuase the sources is safe…it gives me another error message says: no program is registered to open this file…

      please help me i tried many things, but non work

    • #2902938

      Here’s a simple work around

      by brett_phipps ·

      In reply to Hyperlinks in Shared Excel Workbooks/Spreadsheets

      This isn’t true. You can create hyperlinks in shared documents. Just open a new spreadsheet that isn’t shared. Insert the hyperlink that you want there. Copy that cell and paste it into your shared document and voila you’ve inserted the hyperlink.

      I have no idea why it’s disabled when you share them, but this is an easy work around.

Viewing 3 reply threads