Spreadsheet only links to others when they are open

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

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?
 
Back
Top