cannot refer to a cell in another file

  • Thread starter Thread starter 3Suk
  • Start date Start date
3

3Suk

dear all,
my other colleagues excel can refer to a cell "=[fileA.xlss]!sheet1:$A$2" in another cell, but mine cannot, is there any setting in excel preventing this?

thanks in advance
Patrick.
 
if the file is not opened you must add the full path

='C:\blabla...\[fileA.xlss]'!sheet1:$A$2
 
Back
Top