Solver Add-in not working in Excel after macOS Tahoe update

After updating my MacBook Pro with an M-series chip to macOS Tahoe 26.0.1, the Solver Add-in in Excel has stopped working properly. The add-in still opens as usual, but the “Max,” “Min,” and “Value Of” options are all greyed out and cannot be selected. In addition, the “Make Unconstrained Variables Non-Negative” option has completely disappeared from the Solver dialog box

I’m currently running Excel version 16.102 (Microsoft 365 for Mac).

I have already tried the following:

• I have already tried the following:
  • Re-adding the Solver Add-in (unchecked/re-checked).
  • Running Excel using Rosetta 2.
  • Full uninstall/reinstall of Microsoft Office 365.

Several of my fellow students are experiencing the same problem after updating to macOS Sequoia, so it seems to be a broader compatibility issue between Excel and the new operating system.

Does anyone know how to fix this problem or if there’s a workaround available?