Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
How to allow Word table to expand or reduce when linked to excel
Hi
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? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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 :-) |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
How to allow Word table to expand or reduce when linked to exc
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 :-) |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
How to allow Word table to expand or reduce when linked to exc
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 :-) |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
How to allow Word table to expand or reduce when linked to exc
Hi ?B?Tmlja2kgS2luZw==?=,
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. Good. Now press Alt+F9 to see the LINK field code. By default, when using copy/paste, Word will write the absolute cell references (R1C1) after the file and worksheet name. You can substitute a NAMED RANGE for the cell references. Press F9 to force the field to update; alt+F9 will turn the field codes back off. The named range you have to add explicitly in Excel, first. Select the cells, then Insert/Names/Define and type in a name. 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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Convert text in Word to table or Excel | Microsoft Word Help | |||
Inserting Excel tables into Word | Microsoft Word Help | |||
Error with Linked Word and Excel files. | Microsoft Word Help | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables |