Linking to other spreadsheets

ds_robb

Board Regular
Joined
Aug 25, 2002
Messages
72
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
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

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
72
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
 

Forum statistics

Threads
1,147,736
Messages
5,742,895
Members
423,760
Latest member
photogfrog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top