Linked Excel object in Word - undo copy pending

[tatterjack]

I'm linking an Excel spreadsheet into a Word document (Office 97 o
XP)as an icon so that when I double click on it within Word it open
the spreadsheet at a particular worksheet. The method for doing thi
according to Help is to open both, select the data within Excel, clic
copy, move to the Word document and Paste Special using Paste as Lin
and click Display Icon.

All well and good, except when the embedded object opens, the selectio
is still outlined by the migraine-inducing, flashing dotted lines.

How do I get rid of these so that someone opening the link isn't face
with them?

Hitting Esc in Excel obviously removes the migraine but doing thi
before I paste the link empties the clipboard and greys out the past
options. What intrigues me is that if I open the linked spreadshee
directly, the status has been reset but when I open it via the link
this and other conditions at paste time eg window size are retained.



Thanks

 

[tatterjack]

I'm bumping this in the hope of getting a reply, any reply, even if it'
to say there is no solution.

Thanks

 

[tatterjack]

I don't have a complete answer yet but having googled, I've come up with
the following.

The flashing dotted lines (aka marquee or marching ants) disappear as
soon as the office clipboard is emptied for this copy operation. So
simply pressing ESC or closing the Excel spreadsheet ensures that next
time the linked icon is double clicked, the spreadsheet will open
without them.

The highlighted selection in the spreadsheet always appears when the
linked icon is double clicked if it was inserted using
select/copy/paste special. This is intriguing because if the
spreadsheet is opened normally it doesn't show. The information about
which cells were selected must be stored with the link. Deselecting the
cells after or before the paste has no effect.

The only way I've found to cause the linked object to appear without
the selection outlined is to use Insert/Object/Create from file/tick
Link to file & Display as icon. This will always open the linked
spreadsheet on the first worksheet.

To-date I haven't found a way of opening the linked spreadsheet at a
second or subsequent worksheet without the selected cells being
highlighted. But I'm still looking.

Since the problem has changed, I'll repost it. But judging by the
volume of replies, either no one is interested or no one knows. Have I
got the right forum?