Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can't link to Excel2007B2TR Spreadsheet Named Ranges from Word2007
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
embedded Excel sheet in word document - how to use named ranges | Microsoft Word Help | |||
Linking an Excel Spreadsheet in Word | Microsoft Word Help | |||
how to get around broken link? | Microsoft Word Help | |||
How to link a word field to an excel spreadsheet | Microsoft Word Help | |||
Problem Working with Named Ranges | Microsoft Word Help |