Linking to two sheet in one workbook

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have an excel workbook with twenty four spreadsheets in it that rely on
each other being there (can't seperate them into individual files). I am
writing a report in Word that uses some of the sheets in the Excel file via
an "insert object" menu item in Word.

My question is how do I link to an individual sheet? When I link to the
file it brings in the sheet that was open during the last save of the Excel
file. I have to go and open the Excel file, select the correct sheet, save
and exit (if it is not exited it doesn't insert correctly). I would rather
link to something like "\path\filename|sheetname". Is there a way to do
this, can I change the link once made to point to the specific sheet I want?
Any other thoughts?????
 
I think you're stuck with the way excel behaves.

Instead of embedding the workbook in the word document, maybe you could use a
hyperlink to open the workbook to the correct worksheet???

I could insert a hyperlink like this:

C:\My Documents\excel\book1.xls#sheet2!c99
 
select linked object, right click to linked worksheet object, then links...,
change source (back to the original worksheet), before clicking open, click
the item... button. Specify a range name or bookmark in that worksheet.

Let us know if this works.

Keith
 
When I right click on the linked worksheet (inside Word) I get the following
menu
Cut
Copy
Worksheet Object
Edit
Open
Convert
Show Picture Toolbar
Borders and Shading
Caption
Format Object
Hyperlink

There is no Link.. menu item. The Edit and Open only lets you change
numbers in the original worksheet. The Format Object lets you adjust how it
appears in Word but none of them has a pointer to the link.
 
I'm using Office Professional Edition 2003. Are you sure you are inserting
object, create from file (with "link to file" checked)?

Keith
 
I am using Office2003 Pro also. I am using Insert, Object, From File,
Linked.(I have tried both Linked and Not Linked). Try it with a simple
spreedsheet with two sheets containing only one cell with Sheet First and
Sheet Second in the cell of each sheet then insert them into a Word
document.

I have tried a number of things after the filename in the insert routine
such as
filename.ext#sheetname
filename.ext!sheetname
filename.ext|sheetname
but none of these will link and they only put up an error message.
 
email me so I have your address. I've tried to email you without any
success.

Keith
 
I found out the answer. Copy the range of cells you want, switch to Word
and paste special, mark the link box and select as Excel object. The
embedded object behaves as it should. The insert object approach doesn't
seem to work at all.
 
Back
Top