Excel Linked Sheet/Embedded Sheet 
Author Message
 Excel Linked Sheet/Embedded Sheet

I'm having a hard time making a linked spreadsheet work.  I tried embedding the spreadsheet, but then it wasn't updating within the word document, even when I told it to.  

Essentially, I drop the excel file into the word document... but I can't format it (for length, width), and the whole sheet is being added (which I don't need).  

So... my question is on my method, and how to treat it.  Should I be linking documents, and if so, what am I able to do with the linked document (or what am I doing wrong!)?

Thanks!!



Sat, 05 Nov 2005 22:46:00 GMT  
 Excel Linked Sheet/Embedded Sheet

I'm having a hard time making a linked spreadsheet work.  I tried embedding the spreadsheet, but then it wasn't updating within the word document, even when I told it to.  

Essentially, I drop the excel file into the word document... but I can't format it (for length, width), and the whole sheet is being added (which I don't need).  

So... my question is on my method, and how to treat it.  Should I be linking documents, and if so, what am I able to do with the linked document (or what am I doing wrong!)?

Thanks!!



Sat, 05 Nov 2005 22:46:00 GMT  
 Excel Linked Sheet/Embedded Sheet
Hi Erica,

Try copying the sheet in Excel, then Edit/Paste Special in Word. Be sure to activate the "Link" option. If you want the result to be an object, choose that from the list of
formats.

Quote:
> I'm having a hard time making a linked spreadsheet work.  I tried embedding the spreadsheet, but then it wasn't updating within the word document, even when I told it to.  

> Essentially, I drop the excel file into the word document... but I can't format it (for length, width), and the whole sheet is being added (which I don't need).  

> So... my question is on my method, and how to treat it.  Should I be linking documents, and if so, what am I able to do with the linked document (or what am I doing wrong!)?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)



Tue, 08 Nov 2005 01:37:34 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Excel Opens sheet after sheet after sheet,

2. Openning an excel sheet through an other excel sheet

3. Distributing cell values from one Excel sheet to another Excel sheet on another computer - HOW TO

4. Distributing cell values from one Excel sheet to another Excel sheet on another computer - HOW TO

5. Importing an Excel sheet into another Excel Sheet

6. Linking info in one sheet to another sheet

7. Macro to past link from Sheet 1 to Sheet 2

8. VBA to link cell on one sheet to cell on another sheet

9. Linked sheets - Insert rows in all sheets?

10. Linking Sheet Tab Name to Cell in Current Sheet


 
Powered by phpBB® Forum Software © phpBB Group