Hello all

is there a limit to the number of files that you can reference from one sheet

I open workbook1
workbook1 has 2 references
going from upper-right to lower-left the first reference works fine the second returns #REF!

now if I have the workbook referenced in the "#REF" cells open then it returns the correct value "8.0"

is it me or is this a confusing error??

Thanks for any and all help