Linking Excel Charts & Update Source

[LMPaule]

This is a bit complicated so, I will try my best. I asked the question
below:

------------------------------------------------------
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.
------------------------------------------------------------
I got feedback from this group that worked when I was linked to a
spreadsheet. It doesn't work when I have linked to an Excel chart. I
cannot change the source file and have it carry over. Any thouughts on
how to make the Update souce tie to the new file for charts?


Thanks in advance for your help.

LMP

 

[John McGhie]

You can't really do that: A "chart" is an "object" within an Excel
Worksheet within a workbook within an Excel file.

When you switch the link to another Excel file, you need to remake the link
to the charts within it (because they have a unique name in each Excel
file).

If you tell us a little more about what you are trying to accomplish, we may
be able to help further.

For example: If you create the Word Foundation Document and the Excel
Fundation workbook both in the same folder, then copy the whole folder for
each customer, it should do what you want: you get a new Word document and a
new Excel file for each customer. NOTE: The spreadsheet and the document
MUST be in the same folder, not in a subfolder of it.

This is an undocumented work-around: when looking for stuff, Word will
accept any file with the correct name in the same fodler as the document
without looking any further. I doubt if it was supposed to happen: I hope
they never "fix" it

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]

 

[CyberTaz]

See my response to your earlier post.

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