Prev: Can I use a Reference inside a SUMIF or COUNTIF Function?
Next: extract hyperlink with worksheet
From: TamIam on 14 May 2010 11:30
Hi there, is there any way to automatically update linked documents without
opening the source document? When I leave them closed, my main worksheet
shows #VALUE! in the cell, but when I open the source documents, the value is
displayed.

Not sure if this can be helped, but I thought I'd ask

--
Thanks for your help!
From: Luke M on 14 May 2010 13:03
It sounds like you are using the INDIRECT function, otherwise this should
not be a problem. If you are, I'm afraid INDIRECT requires the source
document to be open.

--
Best Regards,

Luke M
"TamIam" <TamIam(a)discussions.microsoft.com> wrote in message
news:ACC10015-60DE-46ED-A212-B531ABF8D169(a)microsoft.com...
> Hi there, is there any way to automatically update linked documents
> without
> opening the source document? When I leave them closed, my main worksheet
> shows #VALUE! in the cell, but when I open the source documents, the value
> is
> displayed.
>
> Not sure if this can be helped, but I thought I'd ask
>
> --
> Thanks for your help!


From: Ashish Mathur on 14 May 2010 20:35
Hi,

You are using one of the following 5 functions (which do not work when the
source workbook is closed) - INDIRECT(), OFFSET(), GETPIVOTDATA(), SUMIF()
or COUNTIF(). Please check which of these formulas are you using. If you
are using SUMIF() and COUNTIF(), the we can solve the problem by using the
SUMPRODUCT() instead (which can work even if the source workbook is closed)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"TamIam" <TamIam(a)discussions.microsoft.com> wrote in message
news:ACC10015-60DE-46ED-A212-B531ABF8D169(a)microsoft.com...
> Hi there, is there any way to automatically update linked documents
> without
> opening the source document? When I leave them closed, my main worksheet
> shows #VALUE! in the cell, but when I open the source documents, the value
> is
> displayed.
>
> Not sure if this can be helped, but I thought I'd ask
>
> --
> Thanks for your help!

 | 
Pages: 1
Prev: Can I use a Reference inside a SUMIF or COUNTIF Function?
Next: extract hyperlink with worksheet