Question

How to link external data in spreadsheet

Answer 1

Explanation:

1:-On the data tab,click existing Connections.

2:-In the show drop-Down list, Do one of the following .

3:- Select the Connection that you want ,and then click open

4:-In the import data dialogue box,Under select how you want to view this data in your workbook do one of the following..

5:- Under where do you want to put the data ..

.

hope this vll help

Answer 2

Explanation:

To open the Load External Data dialog box, click on the Load External Data in the Data Manager or click on the Load option at the bottom of the dropdown for data source selection in the Payoff Specs panel (when creating a calibration payoff).