cannot refer to a cell in another file

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.
 
I

isabelle

if the file is not opened you must add the full path

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Cell data entering slow! 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Excel - Wich Function should I use? 1
name manager to define another workbook 4
Copy addition formula of non-consecutive horizontal cells 2
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Found few bugs in my daily routine of work in excel for MAC 0

Top