@Iamojules
As for excel for mac, my knowledge is, to put it mildly, very limited. But send you this information, it may help you.
Or a Mac specialist will see your post again and may have a solution that can help you:).
Solver on Excel 2011 for Mac
Here are some steps to take to possibly resolve the errors you are seeing. Please try each in order, then check Solver and see if the error(s) remain.
1. Open Excel, click Tool>Add-ins
2. Uncheck the ‘Solver.xlam’ check box
3. Hit ‘Select’ button and navigate to /Applications/Office 11/Office/Add ins/Solver/Solver.xlam> Select the file and hit ok/open.
4. It will give you a prompt saying this Add-in already exists, do you want to replace it.> Say yes.
5. Now on the Excel file try using Solver and see if you still get the same behavior.
If the above steps didn’t help you re-solve the issue, I’ll suggest you apply the latest update for your Office Mac 2011.
To update Office 2011:
- Open any Office application such as Word, Excel, or PowerPoint.
- On the top menu, go to Help > Check for Updates.
- Under "How would you like updates to be installed?", select Automatically Download and Install.
- Click Check for Updates.
Source: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2011/solver-on-exce...
Load the Solver Add-in in Excel
https://support.microsoft.com/en-us/office/load-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e...
Hope I could help you at least a little.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
