Samsung Galaxy S8 review
I'm linking an Excel spreadsheet into a Word document (Office 97 on XP)as an icon so that when I double click on it within Word it opens the spreadsheet at a particular worksheet. The method for doing this according to Help is to open both, select the data within Excel, click copy, move to the Word document and Paste Special using Paste as Link
All well and good, except when the embedded object opens, the selection is still outlined either in black or by the migraine-inducing, flashing dotted lines.
How do I get rid of these so that someone opening the link isn't faced with them?
Granted, and I would have settled for that had I not once, without knowing how I did it, created a link without the aforesaid annoyances. I thought I might be able to do it by hitting Copy and then Esc but this appears to empty the clipboard. What seems strange is that ordinarily if I close a spreadsheet with a copy pending and then reopen, the status is reset but somehow the link preserves this status.
Yes, sorry my earlier response was a bit of a cop-out. I don't know a way round it and, yes, pressing ESC in Excel deletes the contents of the clipboard.
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 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 hihglighted. But I'm still looking.
Many thanks VoG for thinking about it.
This thread is now locked and can not be replied to.