Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking multiple excel worksheets into Word
Hi,
I am linking an excel spreadsheet into Word (2002) using Insert Object. I want to display several worksheets from the same excel file in the Word document. This is easy to set up, but .. if I close and then re-open the Word document all places in the Word document display the same identical worksheet. The only solution it seems is to split the excel worksheets into seperate files. Not an elegant solution. Any ideas? Thanks Rod |
#2
|
|||
|
|||
Linking multiple excel worksheets into Word
Hi Rod
Insert Object might not be the best way to go. The following method works for me. Select the range in Excel and do Edit Copy, Change to Word. Edit Paste Special. Choose Paste Link, and choose Microsoft Office Excel Worksheet Object. Now, click OK. The field that Word inserts is something like the following: { LINK Excel.Sheet.8 "Book1" "Sheet1!R1C1:R3C3" \a \p } So I can see that the link is to a specific range in a specific worksheet. By the way, if you don't need to edit the Excel file from within Word, you might consider pasting as a picture when you do Edit Paste Special. It can still be linked to the Excel file, and therefore update when the Excel file updates. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "reades" wrote in message ... Hi, I am linking an excel spreadsheet into Word (2002) using Insert Object. I want to display several worksheets from the same excel file in the Word document. This is easy to set up, but .. if I close and then re-open the Word document all places in the Word document display the same identical worksheet. The only solution it seems is to split the excel worksheets into seperate files. Not an elegant solution. Any ideas? Thanks Rod |
#3
|
|||
|
|||
Linking multiple excel worksheets into Word
Thanks Shauna,
This does what I am looking for. Never thought about using paste special, strange Word help doesn't point in this direction. Incidentally I didn't get "\a \p" am I missing out on something? Thanks again Rod PS just peeked at your site, looks interesting especially the Styles stuff - I might get to understand this one day. "reades" wrote: Hi, I am linking an excel spreadsheet into Word (2002) using Insert Object. I want to display several worksheets from the same excel file in the Word document. This is easy to set up, but .. if I close and then re-open the Word document all places in the Word document display the same identical worksheet. The only solution it seems is to split the excel worksheets into seperate files. Not an elegant solution. Any ideas? Thanks Rod |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Excel tables into Word | Microsoft Word Help | |||
Envelope Address | New Users | |||
Linking Excel and Word Docs | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Word Field Codes in Excel data file | Mailmerge |