This user guide lists some of the possible causes that can cause compilation errors in the hidden module thisworkbook office 2003. Next, I will provide you with possible solutions that you can try to solve this problem.
After searching repeatedly for answers to this problem, I finally got this idea … If anyone other than me still has this problem, I hope this helps.
Excel displays “Compilation error in hidden module: this workbook” when opening or closing.
This error occurs due to corruption of 2 Excel files.
To prevent the error from occurring:
In Windows XP, open the following folder:
C: Documents and Settings USERNAME Application Data Microsoft Forms, where USERNAME is the current user
In Windows 7, open the following folder:
C: Users USERNAME AppData Roaming Microsoft Forms, where USERNAME is the current user
Once the folder is found, delete these 2 files
Excel should now open without an error message.
Note. Excel will create two new files (with the same name) in the folder, but they will not be damaged.
Why Does A Compilation Error Appear In A Hidden Excel Module?
Microsoft is updating Office 2016 from 32-bit to 64-bit. This error message “Compilation error in hidden module” usually appears when there are 32-bit versions available There are some Office Dome add-ins that are incompatible with the most recent version.
The most common cause of this error is when certain conditions are met:
1: MS Excel launch folder if both template files are included in the Adobe Acrobat PDF Maker add-in:
2: Norton Anti-Virus software is installed.
Now that you know the reason that is causing the compilation error in the hidden Excel module. Let’s start with solutions to fix this error.
How To Fix Compilation Errors In Word / Excel?
- Update Adobe Acrobat
- Run Stellar Repair for Excel
- Move the Pdfmaker files to another folder
- Re-register OCX files using command line
- Update your Norton antivirus software.
- Uninstall Norton software