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

linking information between word

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking information between word and excel

Linking information between word and excel

ResolvedVersion 2003

Kaylee has attended:
Word Intermediate course
Word Advanced course
Excel Intermediate course
Excel Advanced course

Linking information between word and excel

details on linking information between word and excel

RE: Linking information between word and excel

Hi Kaylee,

You can link information either way but it works best when linking excel information into Word. Depending on where your copying your information from go to edit / paste special / click paste link which is on the right of the box, and click OK. Once you have done this you will get your information appearing. The best thing with links is that you don't have to have both files open, but when you do open the other file you do get the option to update your information. If you have done the link from excel into word a handy tip is that if you want to go to the excel file even if it is not open you can double click the linked information. This then opens excel at the spreadsheet.

If you need to make any changes to the link, or if it does not automatically update, then you need to go to Edit / links.

Hope this helps
Regards
Martin

 

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:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

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.11 secs.