Question

write the steps to link two workbooks. Use any example to explain the concept​

Answer 1

The process of linking data between Excel worksheets and/or workbooks actually only involves a few simple steps:

• Open all of the Excel files that you want to link.

• Pick the linked data's Destination cell.

• Select the Soure Data to be linked.

• Press the Enter key.

Answer 2

Explanation:

Press Ctrl+F to launch the Find and Replace dialog.

Click Options.

In the Find what box, enter . ..

.

In the Within box, click Workbook.

In the Look in box, click Formulas.

Click Find All.

In the list box that is displayed, look in the Formula column for formulas that contain .

To select the cell with an external reference, click the cell address link for that row in the list box.