hyperlinks

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hyperlinks

Hyperlinks

resolvedResolved · Urgent Priority · Version 2003

Thomas has attended:
Excel Intermediate course

Hyperlinks

Hi,

I am trying to add hyperlinks to cells in a spread sheet and am having trouble opening them when the spread sheet is sent to different people via email. I want to add PDF files to some cells and word documents to others. Do I need to save these documents as web pagers for them to work once the spreadsheet is sent to my colleagues via email?

Your help would be greatly appreciated.

Thanks
Tom

RE: Hyperlinks

Hi Thomas,

Thank you for your question.

Do the people you are sending the files to all have access to the location of the original files? You may need to check their permissions.

Are the files on a shared drive?

Are you using Insert Hyperlink and then choosing the file?

Regards

Simon

RE: Hyperlinks

Hi Simon,

Thank you for your reply.

Yes the hyperlinked files are saved on a shared drive that all recipients of the excel file have access to.

Also, yes I am using insert hyperlink and then choosing the file.

Many Thanks,
Tom

RE: Hyperlinks

Hi Tom,

Thank you for your response.

There may be an issue with the Macro Security settings on each machine so check through Tools - Macros - Security.

Here is a link to a site that outlines the response by Microsoft on this issue which involves downloading the service pack.

www.tinyurl.com/hyperlinkproblem

I hope this helps.

Regards

Simon

Sun 19 Sep 2010: Automatically marked as resolved.


 

Excel tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips


Server loaded in 0.09 secs.