How to Define the Spec Range in a Financial Reporter Spreadsheet in Sage 300

Steps:

  1.  With the statement spreadsheet open in Excel, select the complete report specification, from the first row and column to the last row and column. 
  2. On the Excel Ribbon, click Formulas > Define Name.
  3. Type Spec as the range name, then click OK.
    • Important! You must type exactly these letters, although the capitalization doesn’t matter.

Note: You do not define a Report range for the spreadsheet. Financial Reporter defines the Report range when it generates the report from a specification.