Link KPI Value to Certain Cell in Excel File

BSC Designer can link KPI value to the certain cell in Excel file:

  1. Go to the KPIs tab
  2. Select any indicator
  3. Switch to the Data tab below
  4. Click Data Source button Data source button
  5. Select Link to MS Excel
  6. 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.

Additional tips