Solved: Excel Paste Special Link

[myrc60]

I have an Excel spreadsheet that I need to link to a Word document. Because the spreadhseet is several pages long I've given each page a range name and now need to link each of those ranges to a separate workbook but I can't figure out how to do that. HELP!!!!!

 

[Anne Troy]

Select each named range, copy, and edit-paste special, link.

Is something wrong with this method?

 

[myrc60]

Ok, I can handle that but the formatting doesn't seem to paste right. Is that right, or am I missing something? I've also got a bunch of 0's where I have blank cells.