Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
excel spreadsheet to word
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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
excel spreadsheet to word
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 |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
excel spreadsheet to word
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 |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
excel spreadsheet to word
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 |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
excel spreadsheet to word
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 |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
excel spreadsheet to word
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge an excel spreadsheet into word | Mailmerge | |||
Excel spreadsheet in Word | Microsoft Word Help | |||
excel spreadsheet to word doc | Microsoft Word Help | |||
excel spreadsheet into word | Tables | |||
excel spreadsheet to word document HOW? | Microsoft Word Help |