Forum Discussion

vpi321's avatar
vpi321
Copper Contributor
Jul 19, 2022

Error Message in Running Excel

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

Macros and VBA
  • PS8888's avatar
    PS8888
    Copper Contributor
    Jul 19, 2022

    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.

    • vpi321's avatar
      vpi321
      Copper Contributor
      Jul 23, 2022

      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 

      • PS8888's avatar
        PS8888
        Copper Contributor
        Jul 25, 2022

        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-a6b40c5bb88b

         

        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. 

Share

Resources