Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Mac NorLog Mac NorLog is offline
external usenet poster
 
Posts: 4
Default Linking excel tables in Word 2007

Can someone help me with what I think should be an easy task but is proving
anything in Word 2007. I use documents in word that contain excel tables
to hold data that require formula. The results in the first table affect the
data presented in the second table & so on. I assumed that a simple "Paste
Link" would do the trick but although I can do the link when changing the
data in the first table, the data in the second changes the first time but
any subsequent changes are not registered & the second table remains
unchanged. When I then go into the table to view the cell formula there is a
reference to the
first table but the cell address appears as RxCx & then displays an error
##REF in the cell. Having followed some of the discussions I have upgraded
with all the current upgrades for Office, however, this only had the effect
of causing my original file to become corrupt & cannot now be open.
It appears that once the file is saved that the link becomes static &
therefore doesn't change with the source data. It has been suggested that
this can only be solved by use of macro's, an area I am not familiar with.
Can anyone help?

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking excel tables in Word 2007 Mac NorLog Tables 1 August 6th 08 02:10 PM
Linking Excel data into pre-existing Word tables Neil Tables 0 October 4th 07 07:01 PM
Linking or embedding an Excel 2007 workbook in Word 2007 MikeJacobs Microsoft Word Help 4 May 7th 07 06:46 PM
Linking Excel tables in Word? Foster Tables 1 April 27th 05 06:38 PM
Linking Excel data to tables in Word KSit Tables 3 November 26th 04 09:36 PM


All times are GMT +1. The time now is 11:37 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"