Thanks for the explanation, but unfortunately that is not the issue. The
Edit/Links & ALT+F9 functions both work beautifully when I paste in my Excel
charts, since they are formatted in line with text and there are no text
wrapping issues.

The problem occurs when the Word document is LOCKED. Parts of my document
are form-protected for other users, but since it is meant to be a sort of
template, they need to be able to reference a different spreadsheet file for
the excel charts. I have tried to retain the Edit/Links & ALT+F9
functionality by placing the excel charts in UNPROTECTED SECTIONS of the word
document, but the Edit/Links ability disappears completely when the LOCK is
flipped on. There are lots of charts, so re-pasting each one would not work.
I would also not like to allow users to unlock the document. Is there some
way to get around this? i.e., Change some aspect of the form-protection?
Have the file path appear next to the linked object in hidden text so that it
can be manipulated that way? Super-unprotect the unprotected sections of the
word doc? Set the entire thing up a different way? Please & thank you thank
you thank you.


"Cindy M -WordMVP-" wrote:

Hi ?B?TGF1cmE=?=,

I don't know what you mean. If I select the excel worksheet object or put
my cursor next to it, & hit ALT+F9, nothing happens. Is a dialogue box
supposed to open? Or is there a way to have the "path" appear in text in the
doc so that it can be edited directly? (Why can't I just select "Links..."
like usual?!?!?)

When I say "inline with the text" I mean that no textwrap formatting has been
applied to the graphical object. You need to get these out of the drawing layer
in order for Edit/Links to "see" them.

Format them "in line with the text" and you should be able to see the links
(either through Edit/links or Alt+F9). Make sure they're in their own paragraph,
select them, then click the Insert Frame button on the FORMS toolbar. Now you
can position them with text wrapping around the frame, and the graphic's link is
still accessible.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)