Word: Create Excel Link to 2 named ranges

**Nadine Klug** · 01-22-2013, 05:18 AM

Hi
I would need help on the following issue

I got a word document, which links to parts of an excel file.

I was able to create a link to a normal named range in Excel which d
LINK Excel.Sheet.8 "path" "Sheet1!R4C3:R62C7", this does also work if the reference is a named range, like LINK Excel.sheet.8 "path" "namedrange1"

BUT
now i have to create a named range which references to something like this "Sheet1!R4C3:R62C7,Sheet1!R80C3:R89C7"
This does not work, not with a named range, not with combined named range, not written like above.
Does anyone have an idea on how this can be solved?

(Office 2007 / 2010)
Thank you.

**macropod** · 01-30-2013, 03:10 AM

You'll need to either:
• use two LINK fields - one for each range; or
• create a separate worksheet that consoldiates the data and link to that.

**lampje77** · 03-07-2013, 04:32 PM

Hi, I'm trying to find the same answer. Did you find a workaround for your problem?

**macropod** · 03-07-2013, 05:37 PM

Originally Posted by lampje77

Hi, I'm trying to find the same answer. Did you find a workaround for your problem?

Did you read the previous reply?

**lampje77** · 03-08-2013, 06:32 PM

yes i read the post. I just dont like giving up. :-)

**macropod** · 03-08-2013, 08:27 PM

OK, so my reply gave two possible solutions, not a mere workaround. Why, then, are you looking for a workaround? That suggests neither solution is adequate.