Error Message in Running Excel

New Contributor

I have Solver, Analysis TooPak, and Analysis ToolPak VBA Add-Ins installed on Excel.    Every time when I open and close Excel Application, I get the error message "Compile Error in Hidden Module: SolverCode".  My PC is running on Windows 10 but I don't get the message on my Mac.  I have uninstalled and reinstalled Office 365 but the issue persists.  According to Microsoft Tech Support, they won't be able to do anything about it since the Add-ins were from third-party developer.  Any suggestion?

 

thanks

4 Replies

Please check if ActiveX and Macros are enabled in Trust Center settings.
File -> Options -> Trust Center -> Trust Center Settings

 

update: I just tested it on my end. If I disable ActiveX controls I get the same error message.

@PS8888 

 

Thanks, it appears working after enabling Active X.

@PS8888 

 

Discard my last reply.  I thought the issue was resolved.

 

I did not get the error message when I open an Excel file from OneDrive but I get the same error message when I open excel from the PC. 

 

Thanks 

@vpi321 

 

1. Ok you have a couple of options. you can disable the Analysis and Solver add-ins, if you don't use them.

  1a:  in excel go to file -> options -> add-ins -> (near the bottom) Manage (select Excel Add-ins) -> Go.

 1b: then uncheck the solver and toolpack addins

 

 

2. You can run the office 365 repair tool to try and fix any damaged files or configurations.

2a: press start -> search for apps and & features. - > select office365 -> modify -> search for repair option.

https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b4...

 

3. If the top two options don't work for you, it would be worth checking your anti-virus solution. ActiveX is old technology and heavily exploited when it was available in internet explorer. You could have anti-virus software running that's trying to keep you safe.