Skip to content
English - United States
Contact us
  • There are no suggestions because the search field is empty.

Fix unresponsive Add or OK buttons in Solver add-in (Excel)

This article explains known steps to troubleshoot unresponsive Add and OK buttons when adding variables in the Solver add-in for Excel.

Summary

  • If the Add or OK buttons do not respond when adding variables, try clearing the add-in cache, reloading the task pane, removing and re-adding the add-in, and testing in another workbook.

Diagnose where the issue appears

  • Confirm whether the Solver task pane (side panel) is visible. The Add/OK controls are in the side panel.
  • Note behavior: Cancel still responds while Add/OK do not. This is a useful symptom to confirm before proceeding.

Steps to clear cache and reload the task pane (Windows / browsers with DevTools)

  1. Right‑click the Solver task pane (the side panel).
  2. Select Inspect (opens developer tools).
  3. In the Inspect pop-up, open the Network tab.
  4. Check the box for "Disable cache".
  5. With the developer tools open, right‑click the task pane again and select Refresh (reload the task pane).
  6. Try Add / OK again.

Steps to clear web cache from the task pane (when an information icon is available)

  1. Click the small "i" (information) icon in the top right of the task pane.
  2. Select "Clear web cache".
  3. After clearing, right‑click the task pane and select Reload (or refresh the task pane).
  4. Try Add / OK again.

Remove and re-add the Solver add-in

  1. In Excel go to Home >> Add-ins >> More Add-ins >> My Add-ins.
  2. Click the three dots on the Solver add-in and choose Delete to remove it.
  3. Reload the Solver add-in through the Add-in Store (add it again).
  4. Open the Solver task pane and try adding variables again.

Other simple checks

  • Test the same operation in a different workbook to see if the problem is workbook-specific.
  • Verify the variable cell address is entered correctly (for example, use "H11" rather than a plain number).

Notes on platform differences

  • On some platforms (e.g., Excel for Mac), the usual right-click Inspect option may not be available. In that case, use the task pane's information menu ("i") to clear web cache and then reload the pane.

If these steps do not resolve the issue

  • Try the sequence again: clear cache, reload task pane, then remove and re-add the add-in.
  • If the problem persists after these steps, further assistance may be required.

Conclusion

  • Common effective actions are clearing the add-in/web cache, reloading the task pane, and removing + re-adding the Solver add-in. Also verify the task pane is the UI being used and confirm cell addresses are entered correctly before clicking Add or OK.