How To Reference Cells in Other Excel Files

Here is the problem if we maintained lots of data and report in Microsoft Excel, and we use several files to handle that data say for instance we use separate file for the list of inventory in the previous period or quarter and want to sum-up the inventory of the previous figure to the current figure using the two excel files.

Here is the formula that will help you.  

Like my previous post about How to Reference Cells in Other Sheet http://toxiod.blogspot.com/2011/12/how-to-reference-microsoft-excel-cells.html their is also a way on How To Reference Cells in Other Excel Files by using the formula similar to the previous example we just add the path where the excel files reside plus the name of the particular file. here is the formula ('The Path of the File\File Name\[Sheet Name]Sheet Name' Exclamation Point Cell Name)

Say for instance if we want to get the sum of the figure that contained from two separate excel files named Book1 Sheet1 Cell A1 and Book2 Sheet1 Cell A1 and want to display the result to other excel file named Book0.

here is the actual formula assuming that our file resided from Drive C

=SUM('C:\Book1\[Sheet2]Sheet2'!A1+'C:\Book2\[Sheet3]Sheet3'!A1)