Getting value from another excel file

  • Thread starter Thread starter ltamisin
  • Start date Start date
L

ltamisin

Hello

I need to know the formula on how to get values from another excel file.

Help plsssssssssssssssss...

thanks
 
Hi Anne

Is there any other way or formula to do that? Coz if i do that there is a
textbox appearing in my worksheet and i have to fix the size in order to fit
the cell and that was very annoying becoz i have so many cell to link.

Pls help....

Thanks
Leo
 
When the other workbook is open

='[otherbook.xls]Sheet1'!$A$1

When it is closed, something along the lines of

='C:\MyTest\[otherbook.xls]Sheet1'!$A$1
 
Just to add to Bob's reply...

I like to open both workbooks.

Then start typing the formula with an equal sign.

=

Then go to the other workbook, other worksheet and click on the cell that I need
to return.

Then excel will build the formula.

Like Bob wrote, it'll look something like:

=[Book1.xls]Sheet1!$A$1

But if that cell is empty, this formula returns a 0.

So I'd modify it to:

=IF([Book1.xls]Sheet1!$A$1="","",[Book1.xls]Sheet1!$A$1)

And when I close book1.xls, xl will do all the drive/folder stuff for me.

=IF('C:\My Documents\excel\[Book1.xls]Sheet1'!$A$1="","",
'C:\My Documents\excel\[Book1.xls]Sheet1'!$A$1)

(all one cell)

Let excel do the heavy lifting so you don't have to remember any of the syntax.
 
Back
Top