Updating Values of Embedded Spreadsheet

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

macropod
Mon Aug 11 14:04:48 PDT 2008

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@discussions.microsoft.com> wrote in message news:9DD08C10-3618-49B8-862B-F0B4A8A1D4C6@microsoft.com...
>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
>

gordon
Tue Aug 12 08:16:12 PDT 2008

No on the first. When I activate the spreadsheet, the values do not update
I do have the update automatic links at open selected.

"macropod" wrote:

> 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@discussions.microsoft.com> wrote in message news:9DD08C10-3618-49B8-862B-F0B4A8A1D4C6@microsoft.com...
> >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
> >
>

macropod
Tue Aug 12 14:19:14 PDT 2008

Hi Gordon.

What are you using SUMPRODUCT for? From what I can see, all its doing is referencing a single cell, in which case a simple external
reference should do the same.

I'm also concerned that the link looks malformed. I think it should look like:
'C:\Documents and Settings\cashmoregf\Desktop\[2008_Injury_Report.xls]2008 Injury Rpt'!$O$4
or:
'C:\Documents and Settings\cashmoregf\Desktop\[2008 Injury Report.xls]2008 Injury Rpt'!$O$4
In fact, the link should look exactly the same as it would if you had linked two workbooks together.

--
Cheers
macropod
[MVP - Microsoft Word]


"gordon" <gordon@discussions.microsoft.com> wrote in message news:B84582B0-94B1-41A7-B0F7-60CFB6B0BF95@microsoft.com...
> No on the first. When I activate the spreadsheet, the values do not update
> I do have the update automatic links at open selected.
>
> "macropod" wrote:
>
>> 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@discussions.microsoft.com> wrote in message news:9DD08C10-3618-49B8-862B-F0B4A8A1D4C6@microsoft.com...
>> >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
>> >
>>