Unlike previous releases of the Real Statistics Resource Pack, the latest release, Release 4.6, uses Excel’s Solver capability. This means that you must make sure that the Solver addin is loaded on your computer
You do this by pressing Alt-TI (i.e. hold the Alt key down and press T and I) and making sure that there is a check mark next to Solver on the dialog box that appears.
Charles