#1
|
|||
|
|||
Linking between embedded excel and word table
I am trying to create a Word template that includes an embedded spreadsheet.
This spreadsheet has a calculation in it that I want to link to in a word table (as a summary). This means that when the embedded Excel updates then the paste linked value in the Word table will also update. I am creating this as a template. However, when I start a new document from the template the links are gone!. Any thoughts please. SFG |
#2
|
||||
|
||||
There is a problem in trying to link to an embedded object based on a template, in that the link will only point to the object in the template, not to the object in the document created from it. Furthermore, if you try to create such a link in a file that hasn't been saved, a crucial part of the link - the filepath - will be missing. In this situation you would probably be better served by using a Word table instead of an embedded workbook.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi Paul
thanks for your answer. What has been happening now makes the sense. I will give the Word table another go, although I have had issues with the calculations not refreshing.... |
#4
|
||||
|
||||
Unless you're using formfields or macro-driving content controls, Word field calculations, though automatic, are not dynamic. That said, you may be interested in my Microsoft Word Field Maths Tutorial, in the 'Sticky' thread at the top of this forum: Microsoft Word Field Maths Tutorial
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
linking excel table to a word table | Mukapa | Word | 0 | 06-23-2016 11:13 PM |
Linking cells between two embedded Excel objects in a PPT file | ACaughey | PowerPoint | 0 | 12-04-2015 09:44 AM |
Scroll bar problem with an embedded Excel table | chrisge | Word | 1 | 09-26-2013 06:18 PM |
update one embedded excel table based on another excel table | ajetrumpet | Word | 0 | 07-05-2013 08:51 PM |
Linking Excel Table to Powerpoint | gsteveli | PowerPoint | 0 | 05-25-2011 07:50 PM |