The conversation titled "Updating number of rows in linked excel object"
started on 2008-07-24 has info. about adjusting the rows and using range
names that you might find useful.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Henk57" wrote in message
...
april;2890031 Wrote:
yes, thanks for finding it.
i tried the solution - namely alt+f9 and substituted the range name -
also
tried to change the range. in both cases, the solution didn't work.
the
linked word document added the extra rows but truncated the bottom of
the
report - even though i changed the range in the link - using the alt +
f9.
any other solutions?
thanks
--
aprilshowers
"DeanH" wrote:
-
IS this your previous posting?
http://tinyurl.com/6njrgv
"april" wrote:
-
i posted this question last week, received a reply, printed it and
now i
can't find the hard copy or the original post.
PROBLEM: i have an excel workbook with many tabs (Balance sheet /
Income
Statement / Cash Flow, etc) and want to link these sheets to an audit
report
which is a word (2003) document. i have named ranges. whe i try to
copy
the range and then paste special - paste link - i get the message
"word
cannot obtain the data for the excel.sheet.8link". i think that i
need a
named range because the link is in the R1C1 format and if i add rows
to the
excel spreadsheet the link does not update with the additional rows.
sorry for posting this twice - thanks in advance for your help.
by the way, when i receive the email notifying me of a response and
then
click on the hyperlink, my internet opens up to a blank screen. any
suggestions?
--
aprilshowers--
Linking a copied range from XL to Word isnt dynamic in the sense that
ranges are adjusted for their dimensions (matrix size), so adding rows
or columns to your previously defined matrix indeed will not be
understood by Word, and you need to redo the c/p for the new range.
However, HIDING a row (or column) will be reflected in the Word doc.
So if you are able to anticipate rows/cols that might be added in the
future, you can define these rows and columns in yr matrix, and hide
them as long as they are empty. When filled later, unhide them and
Word will display them.
I dont know of a way to use range names, otherwise you could use the
OFFSET command (in XL) to create a so-called dynamic range name. This
is a trick to remember, though, if you are going to link to charts and
dont want to display the future months in zero's. An internet search
for "dynamic range name" will get you examples how to use this
concept.
HTH - Henk
--
Henk57