i trie the code that you bue it only worked once after i closed and saved the
file when i reopened it id didn't work again

"Jacob Skaria" wrote:

Try in the below format...Rename the sheet name to suit.

='d:\[B.xlsx]Sheet1'!$A$1:$C$46

--
Jacob


uk" wrote:

=D:\[B.xlsx]!sht!A1:c46

i have tried the above code and several variations of it but i can't get the
data from book b