Sep 06 2022 12:42 PM
I tried lots of things. But, not solved yet. please help.
Sep 07 2022 02:11 AM
This Compile Error In Hidden Module error message usually appears when there are 32-bit add-ins versions of Office that are incompatible with the newer Excel version.
Uninstall all AddIn's and restart Excel, when the error is fixed, activate one AddIn at a time to see which AddIn is the problem.
This error also occurs if you have recently upgraded or saved an Excel file that was created between versions to a different location.
To fix this issue you can run the following (no guarantees :):
Select the file that was incorrectly saved in Excel
Press Alt + F11 to get into the Visual Basic Editor file.
From the Tools menu choose References
Scroll down to Available References Enable and disable anything that starts with MISSING:
Press Alt + Q when all reference errors have been disabled.
Hope I could help you with these information / link.
I know I don't know anything (Socrates)
Sep 10 2022 08:26 AM
Mar 04 2023 06:32 PM
Microsoft Support found the root cause of this problem affecting Excel and Word on my Dad's PC. It was caused by a third-party add-in called 'Sapro Systems WinCalendar v4', though in your case it may be a different incompatible add-in. Fixing it was a matter of disabling the add-in. For Word, they disabled it by finding the Office startup folder and located the add-in file there - they moved the file out of that folder (which disables the add-in). Sorry, I can't remember the exact path of that folder, but it was under a c:\users\[Windows username]\ sub-folder. There would be an option in the Word front-end to access the Add-ins settings screen (similar to what I have described below for Excel).
For Excel, you should be able to access the add-ins as follows:
1. Launch MS Excel.
2. Create a new, blank worksheet (or open any worksheet).
3. In the middle of the title bar of the Excel window, there will be a search field containing the hint text: "Search". In that field, type "add-ins" (without the quotation marks) into that field and hit the 'Enter' key. This will display a menu of search results. In the search results, select 'Add-ins', which will be located under an 'Actions' sub-heading - this option will be shown with a 'cog' icon indicating that it is a settings/configuration option. That option will open the Add-ins dialog.
4. All add-ins will be listed in the Add-ins dialog. If any add-ins are active, then note what they are (so you can progressively enable them afterwards), untick the ticked check-boxes to disable them and click 'OK'.
5. Close and re-launch Excel.
If that fixes the problem, then the issue was caused by an incompatible add-in. If you had multiple add-ins enabled initially, then you can use an elimination method by re-activating one Add-in at a time to determine exactly which one caused the problem.
Jan 25 2024 09:43 AM
@MargotK3199 I have been struggling with this error for a while. your method helped me to resolve it instantly.
I have noticed that this error populate whenever I press an enter key in Excel on laptop version but no error on Citrix version excel.
I had installed an Add-in that was prepared for Citrix enviroment but I had this add-in installed on both Excel versions ( Excel that was part of MS office in laptop and Citrix Excel)
Now I belive this was due to incompatablity issue on both versions.
Thanks a ton
PKJohnson