Getting value from another excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ltamisin - 28 Jun 2005 07:10 GMT

Hello

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

Help plsssssssssssssssss...

thanks

Reply to this Message

Anne Troy - 28 Jun 2005 08:49 GMT

Easiest method: Go to file 2. Copy cells. Do not close the workbook.
Go to file 1. Edit-->Paste special-->Paste link. Save. Close file 2.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> Hello
>
[quoted text clipped - 3 lines]
>
> thanks

Reply to this Message

ltamisin - 28 Jun 2005 09:43 GMT

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

> Easiest method: Go to file 2. Copy cells. Do not close the workbook.
> Go to file 1. Edit-->Paste special-->Paste link. Save. Close file 2.
[quoted text clipped - 11 lines]
> >
> > thanks

Reply to this Message

Bob Phillips - 28 Jun 2005 09:55 GMT

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

Signature

HTH

Bob Phillips

> Hi Anne
>
[quoted text clipped - 22 lines]
> > >
> > > thanks

Reply to this Message

Dave Peterson - 28 Jun 2005 13:13 GMT

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.

> Hello
>
[quoted text clipped - 3 lines]
>
> thanks

Signature

Dave Peterson

Reply to this Message