To access the 'Report Manager' (also listed as an 'Add-Ins' item) select the 'View, Report Manager.' menu item.

These features are available via the 'Tools, Wizard, Lookup.' and 'Tools, Wizard, Conditional Sum.' respective sub menu items, and not via the 'Add-Ins' window's list. The same applies for the 'Lookup Wizard' and 'Conditional Sum Wizard' 'Add-Ins' items. I know, the above contradicts what 'Excel's Help, Excel Help' menu item's 'Microsoft Office Help window displays - when a search for 'Solver tool' is made, and the 'Add-in programs for Microsoft Excel' link (the last one) is selected. If not installed - navigate though the same folders on the 'Microsoft Office 2004' installation CD and drag them over to the hard disk drive based 'Microsoft Office 2004' 'Add-Ins' folder. Can solve optimization problems previously too large for original Solver. '/Microsoft Office 2004/Office/Add-Ins/').ĭo you see the files 'Solver Library' and 'Solver.xla' in the 'Add-Ins' folder? If so, you have the 'Solver' tool installed - even though it is not displayed in the 'Add-Ins' window's list (obtained via 'Excel's 'Tools, 'Add-Ins.' menu item). Excel VBA add-in that extends Excel’s built-in Solver with a more powerful Linear Programming solver. Locate and open the 'Office' folder, and then it's 'Add-Ins' folder (. Locate and open the 'Microsoft Office 2004' folder (an assumption on my part, since you made no mention of the version of MS Office / Excel you are referring to). If you did indeed select the 'Tools, Solver.' menu item and no 'Solver Parameters' window appears. I am assuming here - that you did not notice this. To access the 'Solver' tool just select 'Excel's 'Tools, Solver.' menu item.

Install excel solver mac