Linking to Excel - More than a basic question

[LMPaule]

I have mastered the basics of linking. This question is a bit more
involved. I have an Excel workbook that I link, multiple times, to a
Word document. I use this for differnt clients. So, I have created the
master workbook and the master Word document. When I need to create
again for a new customer, how do I update the links in Word to the
updated and newly named Excel Spreadsheet? More detail below:

Spreadsheet A linked to Word A

Spreadsheet updated and now saved as Spreadsheet B

Open Word A and want to quickly link to Spreadsheet B and then save a
Word B.

Thanks in advance for your help.

LMP

 

[John McGhie]

Hi:

There is an "Update Links" command. I think it's Edit>Links... You'll have
to look in the Help for it, my Mac is not here at the moment.

You can use that to change all the links in a document at once. Change one
and click the button that says "Update All".

Cheers

--

John McGhie, Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. GMT + 10 Hrs

+61 4 1209 1410, <mailto:[email protected]> mailto:[email protected]

 

[LMPaule]

This doesn't get it done. This updates the data to new input into the
old excel fiel. It doesn't let me change the source file with the
detail of which tab, which cells etc remaining in tact. Please let me
know if there is another way.

THANKS

 

[CyberTaz]

I'm afraid what you're trying to do is impossible the way you're going about
it That simply links to the XL file but not to _specific content_ in that
file. Whatever the foreground sheet is will display in Word. There are two
other options, however:

When you create the new XL file select & copy the content to be linked to,
then;

1- If it's _data_ go to the Word document & use Insert>Picture>Chart. Select
the sample content in the datasheet that appears then use the Edit>Paste
Link. Use the features of the Graph app to style you chart... It's quite
similar to the charting features of XL.

2- If you copy a _chart_ you want to link to (on a chart sheet) select all &
copy. Go to Word and use Edit>Paste Special, click the option to Paste Link:
and make sure Microsoft Excel Chart Object is selected.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[LMPaule]

THANK YOU.

LMP

I'm afraid what you're trying to do is impossible the way you're going about
it That simply links to the XL file but not to _specific content_ in that
file. Whatever the foreground sheet is will display in Word. There are two
other options, however:

When you create the new XL file select & copy the content to be linked to,
then;

1- If it's _data_ go to the Word document & use Insert>Picture>Chart. Select
the sample content in the datasheet that appears then use the Edit>Paste
Link. Use the features of the Graph app to style you chart... It's quite
similar to the charting features of XL.

2- If you copy a _chart_ you want to link to (on a chart sheet) select all &
copy. Go to Word and use Edit>Paste Special, click the option to Paste Link:
and make sure Microsoft Excel Chart Object is selected.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[CyberTaz]

You're most welcome... Just keep in mind that John's recommendation to keep
the source file & the Word doc in the same folder is quite good advice!

Regards |:>)
Bob Jones
[MVP] Office:Mac