Reply
 
Thread Tools Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default link excel to word document

Hi April,

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.

Which version of Word?

In most versions, if the pasted workbook object is "inline with text" (no text
wrap formatting has been applied) you can access the link information through
the field code. Press Alt+F9 and you should see something that start like:
{ LINK Excel.

Toward the end of the field (it ends with: } ) you'll see the Sheet!Range
information. You should be able to substitute your range name for the absolute
cell reference.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default link excel to word document

If you always need the same columns but all of the rows, try e.g.

C1:C15

for columns A to O. As far as I know you cannot use the A1:O10 type range
notation in these links.

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

"april" wrote in message
news
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


Reply
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 03:45 PM.

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"