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: So...
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. 

Resources