Reading Excel Files into Worksheets

If you have Excel files with data and formulas needed by a financial model, you can read data from Excel into worksheets. This copies all tabs, formulas, data, and text.

Note:

If worksheets contain data and you read an Excel spreadsheet, it overwrites data—but links to the model are retained. Because links are determined by cell location, if accounts get overwritten and worksheet links do not change, links to incorrect data may result.

  To read Excel files:

  1. In Strategic Finance, select a worksheet.

  2. Select File, then File Management, then Read Excel File.

  3. Select an Excel file and click Open.