Corporate Editions of the Controller Series make use of advanced functions in Excel's Analysis ToolPak and Solver Add-in. You need to check they are both installed and loaded into Excel. From the Excel menu select 'Tools / Add-Ins' to open the Add-Ins window. | 
