Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
April April is offline
external usenet poster
 
Posts: 50
Default link excel to word document

i want to link an excel worksheet to a word document. the spreadsheet has
multiple tabs. i have name the range that i want to link. copied it and
then went into word - clicked Edit / Paste Special / Paste link / Microsoft
office worksheet object. i get a message that ways "Wod cannot obtain the
data for the excel.sheet.8link" if i don't name the range, the link works
fine. however, if i add lines to the excel spreadsheet it doesn't update in
word. the link shows the range as an R1C1 notation which means that if the
range was A110 and i added lines to the spreadsheet, i would only get the
A1:O10 range when i updated the link.

thanks for your help in advance
--
aprilshowers
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I link Word to Excel...?? Chris Gorham Microsoft Word Help 1 January 20th 08 09:15 PM
link info from Word to separate document in Excel dcase Microsoft Word Help 1 December 22nd 06 05:21 PM
want to link excel data to word document lostnfrustrated Microsoft Word Help 2 June 22nd 06 04:26 AM
Help with Word Excel Link through Macro bob New Users 0 November 13th 05 05:52 PM
Excel Link: Adding rows in Excel does not add cells in Word Jameslp Tables 2 December 9th 04 07:18 PM


All times are GMT +1. The time now is 11:15 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"