Linking cell to another excel file

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

Jasper Recto

How do you link the data from one cell on file1.xls to another cell on
file2.xls? I need a cell to populate data from a 2nd excel file without
having to open the 2nd file. Is this possible? How would I do this?

Thanks,
Jasper
 
Have both files open, and in File1.xls Sheet1 Cell A1 type:

=

then go to WINDOW->File2.xls (this will switch to the second workbook) and
select Sheet1 Cell A1 in File2.xls and hit enter.

Fairly simple.

That will link File1.xls Sheet1 Cell A1 to File2.xls Sheet1 cell A1

ryanb.
 
You can also go through the normal copy routine, switching from workbook
to workbook and paste special, paste link...

HTH
 
Back
Top