View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zxcvbnm6000 zxcvbnm6000 is offline
external usenet poster
 
Posts: 9
Default #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.