How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Mike the Mac Medic Your Own Question
Mike the Mac Medic
Mike the Mac Medic, Consultant
Category: Computer
Satisfied Customers: 8994
Experience:  Over 20 years experience with Apple/Windows desktop publishing, design, troubleshooting
25267123
Type Your Computer Question Here...
Mike the Mac Medic is online now

I need a formula that allows hyperlinks to work in shared excel

Resolved Question:

I need a formula that allows hyperlinks to work in shared excel documents
Submitted: 1 year ago.
Category: Computer
Expert:  Mike the Mac Medic replied 1 year ago.
The short answer is no, there is not. When you choose to share a workbook, some options in Excel are simply not available any more; inserting hyperlinks is one of those options that is removed once the workbook is shared.
If you absolutely must add the hyperlink to the workbook, the only option is to unshare the workbook, add the hyperlink, and then again share the workbook. You'll no longer be able to add any more hyperlinks, but the one you added while the workbook was unshared will work just fine.
Mike the Mac Medic and 3 other Computer Specialists are ready to help you

Related Computer Questions