insert link of excel into word intermittent problem

joel norwood

New Member
Joined
Nov 14, 2011
Messages
2
Hello

I love inserting a link an my Excel data/table into my Word Docs. I use this very frequently. I use preformatted word docs or type over old word docs.

Every so often, when i do the same steps, the table does not appear in the doc. It is about the size of a single line. It has "handles" like a picture. I can double click and edit this graphic, but it does not perform like the link.

I figure there is some type of "hidden code" messing with the format or the inserting of the link. Any suggestions or explanations?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,511
Hi Joel,

When this happens, if you press Alt-F9, do you see something like:
{LINK Excel.# "C:\Path\Filename"}
where the link should be? If not, something has fallen over in the paste link process (perhaps you forgot the check the 'paste link' button) and you've pasted the data as an embedded object instead.
 

joel norwood

New Member
Joined
Nov 14, 2011
Messages
2
thanks for feedback. I have not used the Atl F-9 combo b4. Yet, when the link fails, it does appear like an embedded object. So I undo it and do to the proper steps over and over and it makes no difference (still will not work). What will work sometimes is to scroll to another insertion point in the doc, and paste the link. If it works properly, i then cut and paste to re-arrange the document's contents. This is just inefficient.

any other feedback?
 

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,511
Hi joel,

You might try doing a repair on Office. Howver, as you don't say which Office version or OS you're using, I can't advise the details.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,514
Messages
5,596,612
Members
414,080
Latest member
penguin23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top