[Erik Bo Sørensen]

Hi after "up"grading to Office2007B2TR links from Word to Named Ranges in
Excel no loger seems to work!

Links to Named Ranges (in casu only cells) in spreadsheets the new way:
€¢ In Spreadsheet: [Ctrl-C] in cell
€¢ In Word:
[Ctrl+Alt+V] (Paste Special)
[Alt+L] (Paste Link)
[Alt-A] (As)
[u] (Unformatted Unicode Text)

Creates this field in Word-document:
{ LINK Excel.Sheet.8 "\\\\Server\\documents\\TEMP\\Book1.xlsx"
"Sheet2!Test2Name" \a \t \u }

Alt-F9 displays the content of the cell:
Test2

Which seem to work OK (a lot of new limitations though: It looks in
Office2007B2TR like the spreadsheet name must not contain space or special
characters and the Name of the range must no contain space €¦)

But after saving, closing and reopening the Word document IT DOES NOT WORK
ANYMORE.

When Word tries to update the link to the named range, it creates this
rather disappointing messagebox:

Word is unable to create a link to the object you specified.
Please insert the object directly into your file without creating a link.
[OK]

(Dear MS, I chose Link for a reason!)

And instead of the content of the linked cell, Word displays:
Error! Not a valid link.

The field havent changed. Alt-F9 displays the Field:
{ LINK Excel.Sheet.8 "\\\\Server\\documents\\TEMP\\Book1.xlsx"
"Sheet2!Test2Name" \a \t \u }

This is rather annoying as Im using a lot of references to spreadsheets to
keep my documents up-to-date and consistent.
(Im running Off2k7B2TR en-us on WinXPProfSP1 da-dk)

Anybody have any solutions or ideas?

--
Tanks in advance to anybody who care to answer
Erik Bo