Excel Solver Add-in Error 1004 and "SolverCode" Compilation Error

Question

Hello,

I'm experiencing persistent issues with the Solver add-in in Excel. Every time I try to use Solver, I receive Error 1004. I’ve tried multiple troubleshooting steps, including:

• Using the online version of Excel, but the same error occurs.
• Removing and re-adding the Solver add-in.
• Verifying that Solver is correctly installed via Options > Add-ins.
• Checking that the macro is correctly written.
• Uninstalling and reinstalling the Solver add-in.
• Performing a repair of all Microsoft Office apps, including Office 365.

Unfortunately, none of these steps resolved the issue.

Now, when trying to open Solver from a blank Excel file, I get a new error:

"Compilatiefout in verborgen module: SolverCode. Deze fout treedt meestal op wanneer code incompatibel is met de versie, het platform of de architectuur van deze toepassing."

This happens even when opening a new document and trying to launch Solver.

Could you please assist in resolving this issue?

Thank you.

Answer 1

Hi,

Based on the error message, it appears that error is due to code is incompatible with the version, platform or architecture version.

Please see steps below that will help on resolving the issue:

1. Go to C:\Users<YourUsername>\AppData\Roaming\Microsoft\Excel\XLSTART
2. Look for SolverCode > delete .xlam and .xla
3. Check if issue is still the same Note: Make sure excel is closed when doing this.

If issue is still the same, please reinstall Excel but this time, if you are using 64bit on the current installation, please try to download using 32bit version.