excel spreadsheet to word

[april]

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?

 

[DeanH]

IS this your previous posting?
http://www.microsoft.com/communitie...8eaf&cid=ede6143e-2417-4a05-bcc7-8a669f96784a

 

[april]

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

 

[Peter Jamieson]

Which format are you choosing when you paste the link?

 

[april]

Microsoft Office Excel worksheet object

 

[Peter Jamieson]

When you insert that, you get a graphic that has to fit on a single page,
same as when you choose any of the graphic options. Instead, choose one of
the text options, e.g. formatted text (RTF) or unformatted text (Unicode or
otherwise). Although it just looks like a Word table or plain text, it's
just as linked as the "worksheet object" option - it just doesn't look like
a worksheet object.

 

[Henk57]

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 o
the
report - even though i changed the range in the link - using the alt
f9.
any other solutions?

thanks
--
aprilshowers


:
-
IS this your previous posting?
http://tinyurl.com/6njrgv

:
-
i posted this question last week, received a reply, printed it an
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 audi
report
which is a word (2003) document. i have named ranges. whe i try t
copy
the range and then paste special - paste link - i get the messag
"word
cannot obtain the data for the excel.sheet.8link". i think that
need a
named range because the link is in the R1C1 format and if i add row
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 an
then
click on the hyperlink, my internet opens up to a blank screen. an

suggestions?

Linking a copied range from XL to Word isnt dynamic in the sense tha
ranges are adjusted for their dimensions (matrix size), so adding row
or columns to your previously defined matrix indeed will not b
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 th
future, you can define these rows and columns in yr matrix, and hid
them as long as they are empty. When filled later, unhide them an
Word will display them.

I dont know of a way to use range names, otherwise you could use th
OFFSET command (in XL) to create a so-called dynamic range name. Thi
is a trick to remember, though, if you are going to link to charts an
dont want to display the future months in zero's. An internet searc
for "dynamic range name" will get you examples how to use thi
concept.
HTH - Hen

 

[Peter Jamieson]

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.