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