Hi all,
Just a small problem but it would be great if someone could solve it.
I know how to import data from a worksheet that is in the same excel
file, for example, I want to import the contents of cell C3:
=worksheetName!C3

But how can I do the same thing if I am importing from a different
excel file?
It works for me in so much that it will prompt me to find the
datasource, but this is a painstaking process as, every time I open my
excel file, it asks me to update values, and I have to search for the
escel file each time.

Surely you can say something like:
C:\Documents and Settings\profileName\Desktop\Folder1\worksheetName !C3

I know the syntax above is probably wrong, but does anyone know how to
do it?

Thanks in advance,

Steve


--
drumcode
------------------------------------------------------------------------
drumcode's Profile: http://www.excelforum.com/member.php...o&userid=35170
View this thread: http://www.excelforum.com/showthread...hreadid=549386

there is another post just recently that might help you
but here is some advice

open th two workbook e.g book1 and book2
click on a cell and press = change to book 1 and click a cell and press
enter
should look like this

=[Book1.xls]Sheet1!$F$12

then click

EDIT LINKS STARTUP PROMPT DONT DISPLAY ALERTS AND UPDATE LINKS

as long as the file stays in the same location and the name does not
change should work fine from then


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=549386

If i am understanding the question correctly it should work exactly the
same way as if you are importing from a different sheet in the same
workbook.

So say in cell A1 of sheet1 in one workbook, hit your = key and select
the cell in the other workbook you wish it to read with the mouse.
You should then find that in cell A1 of your original workbook it will
read something similar to the syntax you posted.

You will be prompted each time you open workbook 1 if you want to link
to the second workbook, and as long as you haven't changed the location
it should pick the data up straight away.

Hope that helps.


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=549386

Zygan has put it far more succinctly!


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=549386

Brilliant,
Thats a great help,
a simple enough solution in the end,

Cheers,

Steve


--
drumcode
------------------------------------------------------------------------
drumcode's Profile: http://www.excelforum.com/member.php...o&userid=35170
View this thread: http://www.excelforum.com/showthread...hreadid=549386