Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Hyperlinks

Resolved · Urgent Priority · Version 2003

Reply Thu 9 Sep 2010, 09:15Delegate Thomas said...

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

For upcoming training course dates see: Pricing & availability

Reply Mon 13 Sep 2010, 10:35Trainer Simon said...

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

Reply Mon 13 Sep 2010, 10:46Delegate Thomas said...

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

Reply Mon 13 Sep 2010, 10:56Trainer Simon said...

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 articles

· Sparklines And Splicers: The New Face Of Excel 2010
· Do You Really Need Excel VBA Training?
· How to start using Excel 2007 Functions
· More Tips From Excel's Rarely Used File
· Tips From Excel's 'Rarely Used' File

Please browse our web site to find out more about
excel training seminar and other Microsoft training courses.

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips