Posted: April 24th, 2017

Before you can create an external reference you must first __________.

Before you can create an external reference you must first __________.

Select the cell or cells to hold the external reference.

Open the destination workbook and all source workbooks.

Switch to the source workbooks and click the cells.

Click on Insert Function on the Formulas tab.