Spreadsheet only links to others when they are open

Hi All,

I lost my earleir thread on this q (damn outlook express) before getting a
reply, so apologies for re - posting.

I have a spreadsheet (calcs) linked to two others that feed it data.
If the two 'data feeders' are not open, calcs displays #value errors for all
linked cells.

This is after I have selected 'automatically update during opening of calcs.

Can anyone help identify why this is and how I might change it ?

Thanks,

Neil

There are some functions that don't work with closed workbooks.

=sumif(), =indirect()

What formula did you use in your links?

Neil wrote:
>
> Hi All,
>
> I lost my earleir thread on this q (damn outlook express) before getting a
> reply, so apologies for re - posting.
>
> I have a spreadsheet (calcs) linked to two others that feed it data.
> If the two 'data feeders' are not open, calcs displays #value errors for all
> linked cells.
>
> This is after I have selected 'automatically update during opening of calcs.
>
> Can anyone help identify why this is and how I might change it ?
>
> Thanks,
>
> Neil

--

Dave Peterson