View Single Post
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
April April is offline
external usenet poster
 
Posts: 50
Default 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