View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
Cindy M -WordMVP-
 
Posts: n/a
Default How to allow Word table to expand or reduce when linked to excel

Hi ?B?Tmlja2kgS2luZw==?=,

How can i allow in Word for a table to increase or decrease in size when
linked to an excel spreadsheet that could change in size every month?

Difficult to describe exact steps without knowing the version of Office
involved and how you brought the Excel table into Word, but...

The basic principle is to base the link to the Excel data on a NAMED RANGE
in the Excel workbook. When things are added to the named range, the
information that comes across the link will match. The tricky part being,
if you're adding things to the bottom of the range, making sure the named
range expands to include them.

Is this making any sense to you?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)