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

broken links

ResolvedVersion 2007

Mark has attended:
Excel Intermediate course

Broken Links

How do you deal with this

RE: Broken Links

Hello Mark

Thank you for your question and welcome to the forum.

You can fix a link if you know what has caused it to break - e.g. the source file has been renamed, or moved to a different location.

If you go to the Data ribbon and click the Edit Links button, then use Change Source to navigate to and select the file you wish to re-establish the link with, this will fix the broken link.

Kind regards
Amanda

Tue 3 Feb 2009: Automatically marked as resolved.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.