User Tools

Site Tools


Guide Section: Interacting With Excel Spreadsheets | EASAP Tree: SPREADSHEET LIST Branch

NAMED RANGE LIST is a Parent to NAMED RANGE's. Similar to a SHEET the NAMED RANGE LIST contains an Additional Dependents: parameter for manually specifying Dependent Cells.

Note: The NAMED RANGE LIST is created automatically and populated with all the NAMED RANGE's found in the spreadsheets specified in the EASAP when the EASAP is saved. It is not possible to manually add NAMED RANGE's.

Optional Parameters:
Additional Dependents:Comma-separated list of dependent cells beyond calculated values. NOTE: Re-run dependency calculation after setting. (ie. [1!A5] → Cell A5 in Sheet 1)

An example screenshot of a NAMED RANGE LIST and Child NAMED RANGE's

Page Tools