There are some functions that only work with open workbooks...

=indirect(), =sumif(), =countif()

are a few (IIRC).

sro1 wrote:

why does a formula only work when the linked spreadsheet is open

--

Dave Peterson