LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Cannot link from Excel to Word using named ranges

After installing SP3 for Office 2003, our users can no longer paste named
ranges from Excel into a Word doc. The range is selected and named in Excel,
then copied. I switch to a Word doc and choose Paste Special, then "paste
link" as Microsoft Office Excel Worksheet Object. When I select OK, an error
appears --"Word cannot obtain the data for the Excel.Sheet.8 link."

If the range that I need copied in Excel is not named, then when cells are
added or deleted the entire contents that should be linked in Word will not
be correct.

For instance, if the range A1:B7 is named "fruit" and pasted into Word using
"Paste Special", when 2 additional columns are added, a named range will keep
the info in A1 through the info that was originally entered in B7 (which is
now B9) linked into Word.

If the range is not named but is only copied and pasted into Word using
"Paste Special", 2 additional columns are added, I will only get what is in
A1 through B7 (currently) linked into the Word document.

Any suggestions would be appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I name worksheets in Excel according to named ranges? Dominique Excel Worksheet Functions 4 September 1st 06 09:03 AM
Can Named ranges be used in file link formulae? Philip J Smith Excel Worksheet Functions 3 April 10th 06 01:26 PM
Accessing named ranges in Excel from VBA Basz Excel Discussion (Misc queries) 1 August 10th 05 03:21 PM
Like 123, allow named ranges, and print named ranges WP Excel Discussion (Misc queries) 1 April 8th 05 06:07 PM
How to Link named ranges from multiple Workbooks into a single Wo. PMAP_HELP Excel Discussion (Misc queries) 1 December 14th 04 05:51 PM


All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"