Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
first4Him first4Him is offline
external usenet poster
 
Posts: 1
Default Table from excel, need to auto update, formatting - SIMPLE SOLUTIO

I need to import a table from excel, and have the table update automatically
each time the word doc opens. In addition, the table needs to be reformatted
to the word doc specifications. I thought mail merge would be a solution, but
having trouble getting the records to show up (going to next record, etc.).
I'm sure there is a very simple solution to this problem that I'm pulling my
hair out about.
I've also considered XML mapping... but it's new to me, so not sure if
that's the right way either.
The specific table is an appendix at the end of a very long document.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Table from excel, need to auto update, formatting - SIMPLE SOLUTIO

There is no 'auto-updating' available. It is necessary to force an update.
The most logical way to do this is to set the Word options to update
automatic links on open then paste special the table as a link. Which format
you use will rather depend on your document, but formatted text (RTF) will
probably give you the widest range of re-formatting options.

The link will update immediately as long as both the Excel and Word
documents are open and the changes are made in Excel.

You could add a macro to force an update if required -
http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



first4Him wrote:
I need to import a table from excel, and have the table update
automatically each time the word doc opens. In addition, the table
needs to be reformatted to the word doc specifications. I thought
mail merge would be a solution, but having trouble getting the
records to show up (going to next record, etc.). I'm sure there is a
very simple solution to this problem that I'm pulling my hair out
about.
I've also considered XML mapping... but it's new to me, so not sure if
that's the right way either.
The specific table is an appendix at the end of a very long document.



Reply
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
Simple table calculation: Excel or ??? LurfysMa New Users 2 June 30th 07 01:06 AM
Simple table calculation: Excel or ??? LurfysMa Tables 2 June 30th 07 01:06 AM
Update Excel table in Word automatically from data in Excel yvonnedemulder Tables 1 December 6th 05 06:49 PM
Update Excel table in Word automatically from data in Excel yvonnedemulder Microsoft Word Help 4 December 6th 05 06:49 PM
Word should auto update Formulas in the same way Excel does SmokeyMcPotHead Microsoft Word Help 3 February 26th 05 03:37 PM


All times are GMT +1. The time now is 12:31 AM.

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

About Us

"It's about Microsoft Word"