Thanks for your reply Jean-Guy
Are you telling me that before I embed an excel worksheet in my word
doc I should create it first in excel and get it formatted etc, then
embed it into my word doc.
I didn't do that - I just used Insert>object and created the worksheet
right there in word - which does not give me all the flexibility to
format as excel does.
Joanne
Jean-Guy Marcil wrote:
[Quoted Text] >Joanne was telling us:
>Joanne nous racontait que :
>
>> I have an embedded excel sheet in my word doc.
>> I wonder if I can name a cell (my totaling cell) in the excel
>> worksheet so that I can use it to update a field instead of hardcoding
>> an r1c1 addr that will change under various conditions? I've looked in
>> Word's format/cells, but it doesn't show anything about naming excel
>> cells.
>
>If you name the target cell in Excel, it will work as you want.
>
>Let's say that I name my total cell in Excel "MyTotal" (on Sheet2)
>
>Now, I select that cell and do CTRL-C (Copy)
>I go to Word and do: Edit > Paste Special > Paste Links > Formatted Text
>(RTF) and hit OK.
>
>I get a field that contains the following code (Select the linked total and
>do SHIFT-F9):
> LINK Excel.Sheet.8 Book1 Sheet2!MyTotal \a \f 4 \r
>
>Now if I move the "MyTotal" in Excel, Word will always find it, unless you
>move to a new sheet, in which case you will have to edit the field code to
>let Word know what sheet "MyTotal" is now on.
>
|