why does a formula only work when the linked spreadsheet is open
D Dave Peterson Dec 30, 2005 #2 There are some functions that only work with open workbooks... =indirect(), =sumif(), =countif() are a few (IIRC).
There are some functions that only work with open workbooks... =indirect(), =sumif(), =countif() are a few (IIRC).
