excel spreadsheet to word

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

IS this your previous posting?
http://www.microsoft.com/communities...7-8a669f96784a

"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

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://www.microsoft.com/communities...7-8a669f96784a

"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

Which format are you choosing when you paste the link?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"april" wrote in message
...
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://www.microsoft.com/communities...7-8a669f96784a

"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

Microsoft Office Excel worksheet object
--
aprilshowers


"Peter Jamieson" wrote:

Which format are you choosing when you paste the link?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"april" wrote in message
...
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://www.microsoft.com/communities...7-8a669f96784a

"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

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.


--
Peter Jamieson
http://tips.pjmsn.me.uk

"april" wrote in message
...
Microsoft Office Excel worksheet object
--
aprilshowers


"Peter Jamieson" wrote:

Which format are you choosing when you paste the link?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"april" wrote in message
...
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://www.microsoft.com/communities...7-8a669f96784a

"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

Originally Posted by 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
--
aprilshowers


"DeanH" wrote:

IS this your previous posting?
http://www.microsoft.com/communities...7-8a669f96784a

"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

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