java.lang.NumberFormatException: For input string: "null" Unable to perform Spreadsheet Budgeting in Excel for SCT Banner 7.0.
 
 
HelpInfo
Unable to perform Spreadsheet Budgeting in Excel for SCT Banner 7.0.
Cause of Problem

The problem occurs because Excel is not configured to be used with SCT Banner Human Resource for spreadsheet budgeting.
Solution Summary

Open 'Microsoft Excel'. From the 'Tools' menu, click 'Add-Ins'. Select the 'Desktoptools' check box. Click 'OK'.
Solution Details

The SCT Banner Human Resources allows you to perform tasks, such as manage payroll, work with budgeting policies, and keep a track employee attendance. The Spreadsheet Budgeting application for Human Resources is used to manage information related to salary and position using Microsoft Excel. Spreadsheet Budgeting is an add-in program and Excel must be configured before you can use it with SCT Banner for spreadsheet budgeting.
To enable spreadsheet budgeting in Excel:
1) Open 'Microsoft Excel'.
2) From the 'Tools' menu, click 'Add-Ins'. (The 'Add-Ins' dialog box appears.)
  'Add-Ins' dialog box
3) Select the 'Desktoptools' check box.
  NOTE: If the 'Desktoptools' check box is not displayed, click the 'Browse' button to locate Desktoptools in the appropriate directory.
4) Click 'OK'.
Applies to Software Version

SCT Banner