Link KPI Value to Certain Cell in Excel File
BSC Designer can link KPI value to the certain cell in Excel file:
- Go to the KPIs tab
- Select any indicator
- Switch to the Data tab below
- Click Data Source button
- Select Link to MS Excel
- Follow the steps of import master
What is a named range?
Name range is a more reliable alternative to addressing cells by their coordinates. More in Excel manual.
- The value will be imported into the date selected in the internal calender
- Use Update imported indicators in Tools menu to repeat import