Formulas showing #Ref from closed workbooks

[Peter Davison]

Is it possible for all formulas in a workbook to work when the workbook they refer to is closed?
Some of my formulas work and some show #Ref or Blank Cells until I open the workbook?
Any thoughts and/or help would be appreciated.

 

[RoryA]

Not all formulas work with closed workbooks. If you use functions like COUNTIF/SUMIF, you'll need to replace them with something like sumproduct.

 

[Peter Davison]

Thank you for your help