Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
referrencing excel cells in word
Name: Atomicboy Date: April 17, 2007 at 08:42:22 Pacific OS: varies CPU/Ram: varies Product: me
Comment:
Is there anyway that I can referrence a cell in excel in a word doc much like you referrence cells from sheet to sheet in excel? I have search long and hard for this answer. I am using MS WORD 2002, and excel 2002.
Name: Coldpaws Date: April 30, 2007 at 08:57:44 Pacific
Reply:
Hi, Not sure if this is what you are after and I am working in Exl 2003 but,
You can copy the value in the cell in excel and paste it into word, you can't write the cell reference directly e.g Sheets1("$A$5") . Then in my version there is a small 'paste options' icon . Clicking this gives you a drop down list where you can select 'keep source formatting and link to Excel' If the cell in excel is changed , the value in word can be manually updated by right clicking on the field and selecting 'update link'
If you're not totally confused , you don't fully understand the question.
Summary: charts embedded in a word document, 'pasted as link' from excel s/s will not update when word document is accessed; automatically or manually. all settings in word have been confirmed. running of...
Summary: I tried creating an inventory type file in Excel AND in Word. I found it was much easier to create an Access database for this. So, that's what I use. It's much more manageable, and more importantl...
Summary: Hi everyone, I need some help here. I'm running excel MS office 2007. I have a main file that as a hyperlink to an external word doc. I'd like to place in an cell in the excel file the last modified d...
0 
