#REF! error with Multiple Documents
@Bob Bridges - It is on the same PC and same HDD.
@ JLatham - I copied the equation correctly. Data[#All] refers to the table
"Data" and [#All] indicates that it includes the whole table not just pieces.
I found it odd too, that there is no sheet name, but if I try to enter it,
Excel just updates the equation to what I pasted.
|