Linking to other spreadsheets

ds_robb

Board Regular
Joined
Aug 25, 2002
Messages
74
Office Version
  1. 365
Platform
  1. Windows
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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,217,681
Messages
6,137,953
Members
450,100
Latest member
mscetr

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
Back
Top