Import XL workseet into a MS Word doc that stays current with changes in XL

I want to import a worksheet into a Word doc so the imported worksheet dynamically reflects the changes in the one in XL.
 
I tried doing a copy and, in Word, paste; using "link and keep saved format".  But when I change data in the XL worksheet nothing changes in the copy in Word.
mikecox_Asked:
Who is Participating?
 
DrTribosConnect With a Mentor Commented:
Hi there,

If you go to XL and copy your range then paste into word as you did it should update.

Try closing the word document and reopening.  Do you get a notification that links exist?

Also, in  word options make sure fields are always shaded...  if you don't see shading you might not have links.  Try selecting your links in word then pressing Alt + F9  you should see something like: { LINK Excel.Sheet.## "...Path..." SheetName&Range }

You should be able to update manually by selecting all then pressing F9
0
 
DrTribosCommented:
BTW - Field code shading:
Word Options > Advanced > ShowDocumentContent:
Field shading:  [set dropdown box to "Always"]
0
 
mikecox_Author Commented:
Ok, your too fast for me (-:

I figured it out; well I got it to work, but I'm not sure what I did /-:

I tired your suggestion, to close and reopen, and that forced an update, but it wasn't updating dynamically; on the fly.  So I started over and when I was finished it was working; go figure!

But I forgot about F9; I was looking for "sync"!
0
 
DrTribosCommented:
No worries - glad to help, thanks for the grade
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.