Excel – Is importing one Excel spreadsheet into another Excel spreadsheet possible

importmicrosoft excelspreadsheet

Can I import an Excel spreadsheet into another spreadsheet (two separate files) by linking in certain cells from one to show in other cells in a different file?

I'm not sure if I can do this or where I'd go if it possible to make it work. I have no programming background.

Best Answer

Yes:

  • Open both workbooks
  • Activate the workbook you want automatically updated
  • Select a cell you want to link
  • Type =
  • Activate the other workbook
  • Select the cell you want to link and hit "enter"
  • You will return to the first workbook and the selected cell will contain the reference e.g. =[FirstFile.xls]Sheet1!$A$11
  • Repeat for each cell you want to link

  • If you want to, you could include references in formulae, say if you wanted half the value, you would do as above then add /2 to get =[FirstFile.xls]Sheet1!$A$11/2 or maybe multiply the vales of two cells e.g.

    =[FirstFile.xls]Sheet1!$A$11* =[FirstFile.xls]Sheet1!$B$42
Related Question