Photo Credit: Courtesy of 3DStockPhoto (
can image)
Making a reference to another workbook in
Excel As is the case with creating an Excel formula that references another sheet, you don't have to type a reference to a different workbook manually. Just switch to the other workbook when entering your formula, and select a cell or a range of cells you want to refer to.