Before importing data, configure the Excel file containing the data to import to Metrics Management. The Excel file containing import data must include a named range for Metrics Management to connect to and import from.
How to define a named range in the Excel import file
1 Open the Excel file from which to import data.
2 Highlight the records to import.
3 Choose Formulas➛Define Name.
4 In New Name, provide a meaningful name that indicates what data the range contains. The named range name must not contain any spaces. For example, name the range Import_Monthly_Actuals, as shown in Figure 7‑29. Then, choose OK.
