Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking separate workbooks
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Linking separate workbooks
Resolved · Low Priority · Version 2007
Reply Thu 2 Apr 2009, 14:31Delegate Tracy said...
Tracy has attended:
Excel Intermediate course
Excel Advanced course
Linking separate workbooks
What is the correct procedure for linking workbooks?
For upcoming training course dates see: Pricing & availability
RE: linking separate workbooks
Hello Tracy
Thank you for your question and welcome to the forum.
There are a couple of different ways of creating links; it's not so much that one is more correct than the other, it is down to your preference as to which way you'd like to go about setting them up.
Following either way, you'll need to have both files open (the file you're creating the link in (destination file) and file that the link gets information from (source file)).
Method 1.
1. Click in the cell where the link is to go in the destination file.
2. Type in =
3. Select the cell in the source file that you wish to link to.
4. Press Enter.
Method 2.
1. Copy the cell that you wish to link to in the source file.
2. Select the cell that you wish to create the link in, in the destination file.
3. Right-click and select Paste Special.
4. Click Paste Link (bottom left corner).
Kind regards
Amanda
Thu 9 Apr 2009: Automatically marked as resolved.
|