Re: Updating Values of Embedded Spreadsheet

Hi Gordon,

Does the value update if you activate the embedded worksheet?
Do you have the 'update automatic links at open' option checked under Tools|Options|General?

--
Cheers
macropod
[MVP - Microsoft Word]


"gordon" <gordon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9DD08C10-3618-49B8-862B-F0B4A8A1D4C6@xxxxxxxxxxxxxxxx
I have a spreadsheet that I linked to in my Word Document.
Actually the way I did it was to insert an Excel Worksheet and I put this code below as the value of the cell
=SUMPRODUCT('C:\Documents and Settings\cashmoregf\Desktop\2008_Injury_Report.xls\[2008%20Injury%20Report.xls]2008 Injury Rpt'!$O$4)

This value should then go to the spreadsheet mentioned and grab the most current value in that spreadsheet. However, when I open the Word document the values don't update with what is current in the sheet in the referenced sheet. I'm not sure what I am doing wrong.
How do I make this value update in the document when the Word document is opened. If I put this code in a cell in a True Worksheet and open it, it automatically updateds.

Thanks in advance for any ideas.

Gordon

.

Relevant Pages

  • Appearance of linked excel worksheets in word
    ... I have a lengthy word document which incorporates numerous links to excel ... I am selecting the worksheet area in excel, copying it, ... my word document and on occasions some of the double underlining in my charts ...
    (microsoft.public.word.docmanagement)
  • Re: Printing multiple embedded Word Documents
    ... I have multiple OLEObjects on each sheet ... rather than finding just the Word document. ... On Nov 15, 4:08 pm, Gary''s Student ... Dim sh As Worksheet ...
    (microsoft.public.excel.programming)
  • Re: Word 2002 and Excell 2002 merge issues
    ... I saved the file in the .csv format. ... different ways of connecting to the worksheet. ... If OLEDB didn't work, it tries "ODBC". ... a blank Word document instead, and use that as the data source. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How do you replace a work sheet in excel with a word document?
    ... "Conrad Carlberg" wrote: ... Select and copy the text in your Word document. ... Switch to Excel and select A1 on a blank worksheet. ... > checkbox, and also clear the Row & Column Headers checkbox. ...
    (microsoft.public.excel.misc)
  • Imbedding a Word document into Excel
    ... I am trying to imbed a Word document named INSTRUCTIONS.doc that is ... about 4 pages long into an Excel worksheet (named INSTRUCTIONS (both ... INSTRUCTIONS Worksheet, ... the icon has lost its color and is on a white/ ...
    (microsoft.public.excel.misc)