inserting linked grapic/tables from excel into word

L

Lynda

Can someone help me to create a linked chart in a word
document from excel? I insert the object and create the
link and the graphic (or a portion of it) does appear and
does update, however, I cannot find the place to designate
a sheet and cell range. So whatever sheet I'm currently
on, it inserts from there, but as for the range, I can't
figure it out.

I've tried setting print area, having the section
highlighted, and have tried spelling it out as
[file name]sheet!range:range

Nothing is working for me. Any suggestions. THanks.
 
P

Philomena Connors

Try copying the chart in Excel, then Edit->Paste Special
in Word, check the As Link button and select MS Excel
Object.
Philomena
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top