Perhaps you haven't named a range? Look in Excel's Help for instructions on
doing so (the "Name cells in a workbook" topic) and also on how to extend it
(I think you do this by selecting the range name in the Name box and then
dragging to add to the selection).
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site:
http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"Nicki King" wrote in message
...
Hi,
OK my version of excel and word is 2002. If I copy and paste into word
from the excel spreadsheet and then told it to link to source - where do I
find the NAMED RANGE that you have mentioned.
Thanks
"Cindy M -WordMVP-" wrote:
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 :-)