Linking to other spreadsheets

ds_robb

Board Regular
Joined
Aug 25, 2002
Messages
71
Can anyone tell me if there is a way to link to cells in another spreadsheet without having to open that spreadsheet up each time.

For example if I have two spreadsheet files (FILE1.XLS and FILE2.XLS), and I have a VLOOKUP command in FILE2.XLS that points to cells within FILE1.XLS - do I always have to open FILE1.XLS first to be able to read the contents.

=VLOOKUP(C6,[FILE1.xls]Sheet1!$B$3:$C$6,2,FALSE)

It's a pain to keep having to open the FILE1.XLS first before the formula will work in FILE2.XLS

Thanks
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Chris Davison

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,790
VLOOKUP should suffice entirely....

let me find a similar question raised today.... brb

back...

http://www.mrexcel.com/board/index.php

check out the above thread ( maybe you guys work in the same place ?!)

Keep an eye on his problem too as it may solve yours..... at the very least, I'd recommend you message or email him so he can keep you posted and visa versa...
This message was edited by Chris Davison on 2002-09-15 08:23
 

ds_robb

Board Regular
Joined
Aug 25, 2002
Messages
71
Is there any way then to stop Excel asking about "This sheet contains links to other workbooks" and just have it update anyway.
Regards
Duncan
 

KrisInCrisis

New Member
Joined
Aug 13, 2002
Messages
9
Try..

Tools -->Options-->Select Edit(tab) & Untick "Ask to Update automatic Links" option..

KrisinCrisis
 

Watch MrExcel Video

Forum statistics

Threads
1,118,229
Messages
5,571,019
Members
412,354
Latest member
Stj99
Top