#1   Report Post  
Old November 7th 05, 10:01 AM
JIM.H.
 
Posts: n/a
Default Q: creating link

Hello,
I know I can create link from one excel file to another to gather data on
one sheet. Is it possible to create link in Excel to a table in Word?
Thanks,


  #2   Report Post  
Old November 7th 05, 02:10 PM
Paul Sheppard
 
Posts: n/a
Default Q: creating link


JIM.H. Wrote:
Hello,
I know I can create link from one excel file to another to gather data
on
one sheet. Is it possible to create link in Excel to a table in Word?
Thanks,


Hi Jim

Copy the Word Table, go to your excel file, click on the top left cell
where you want the word table linked to, right click, select paste
special, click in paste link and click ok, your table in excel will
update when you make any changes to the word table

Or you can do the same in reverse from Excel to Word


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=482747

  #3   Report Post  
Old November 7th 05, 06:00 PM
JIM.H.
 
Posts: n/a
Default Q: creating link

Hello Paul,
Thank you very much for the reply. Link seems working for keeping data the
same. I need to perform a few operations on the cells on this table in Excel
such as “sum” and “if”, can I do that? (I can move whole table into excel but
Word table is used by others I just want to create link)
Thanks,


"Paul Sheppard" wrote:


JIM.H. Wrote:
Hello,
I know I can create link from one excel file to another to gather data
on
one sheet. Is it possible to create link in Excel to a table in Word?
Thanks,


Hi Jim

Copy the Word Table, go to your excel file, click on the top left cell
where you want the word table linked to, right click, select paste
special, click in paste link and click ok, your table in excel will
update when you make any changes to the word table

Or you can do the same in reverse from Excel to Word


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=482747




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating a network cell link diepenbos Excel Discussion (Misc queries) 0 September 9th 05 03:27 PM
Paste Link - retaining formatting Suzanne Marie Excel Discussion (Misc queries) 1 August 18th 05 02:02 AM
Creating a link between cells in two different spreadsheets Gina O'Brien Excel Discussion (Misc queries) 3 June 27th 05 12:09 PM
Breaking the link T New Users to Excel 1 May 4th 05 10:37 PM
stop creating email link when @ sign is present gregg Excel Discussion (Misc queries) 2 February 23rd 05 03:03 AM


All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017