Not able to run Solver table Excel

Question

About a year ago I downloaded Solvertable as an add-in in Excel. At that time it worked perfectly and I manage to use it to solve assignments in school.

Now on the other hand, I can't seem to use the function at all. I have tried to delete and install the xls-file for Solvertable again, but it doesn't work. As you can see in the picture below - the installation is done, but nothing happens if i tried to Run Solvertable, neither the other function as SolverTable help and unload.

Could it be something about my settings?

Sometimes I get a error message while using Excel saying something about Disable Macros.

Answer 1

Hi @Fride Lunne Mastad

Welcome to Q&A forum ~

But please note, SolverTable add-ins is a 3rd-party add-in.

I personally suggest you try following steps to have a check.

• Once you download the SolverTable.xlam file, please right-click it > Select 'Properties' > Ensure this file is not 'Read-only', if there is one 'Unblock' checkbox as following image, you need to tickt it > Click Apply and OK.

• • Then go to Excel > Options > Trust Center > Trust Center Settings > Trusted Locations, please make sure the location that you store SolverTable.xlam is set as one Trusted Location. If not, you may click 'Add new location' to add the path.
• • And then go to Macro Settings under Trust Center Settings, select 'Enabel VBA macros', 'Enable Excel 4.0 macros when VBA macros are enabled' and 'Trust access to the VBA project object model'.

Besides, I find the link https://host.kelley.iu.edu/albrightbooks/Free_downloads.htm, there is a 'SolverTable fix' you may have a look.

(Please Note: Since the web site is not hosted by Microsoft, the link may changed without notice. Microsoft does not guarantee the accuracy of this information.)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---