You might receive a 'Compile Error in Hidden Module' error message when you start your Excel.
Whether it is Excel or any other Microsoft Applications from time to time they are prone to errors. This Compile Error in Hidden module occurs in both MS Excel and MS Word but in this blog, you will get to know how to repair Compile Error in Hidden module in Excel.
When you start MS Excel the particular error message that displays on the screen is:
Compile error in hidden module: AutoExec
Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed. Sandboxing restricts the apps from accessing resources outside the app container. This affects any add-ins or macros that involve file access or communication across processes. I'm running Office for Mac and have to work with spreadsheets for preseason orders of product for my business - the companies are all still building spreadsheets for PC, but as my business also involves a lot of photo and video editing, I'm running a Mac. This was always a problem due to VB macros, until Office 2011 dropped and solved the problem. Open Office 2016 for Mac application and turn off the add-ins. Once done, got to Tools and open Templates and Add-ins.; All available add-ins will be displayed in the Global Templates and Add-ins list.
Compile error in hidden module: AutoExecNew
Compile error in hidden module: DistMon
If you are using an older version of Windows like Windows 95/98 then you might receive an error message that says:
Excel has performed an error in module excel.exe and will be closed.
For Windows 2000 and above version the error appears like:
Excel has encountered a problem and needs to close. We are sorry for the inconvenience.
After the error message is displayed, an error report will be presented which provide the additional information of that error, a link will be shown something like:
– 9.0.0.5302 – Vbe6.dll – 6.0.89.67 – 0000d799
Just click on the link to view full details of that error and depending on the application that has been crashed you might see location to excel.exe which will guide you to the culprit of this error message.
To repair Compile Error in Hidden module go through the solutions one by one but before that get to know why does this Compile Error in Hidden module in Excel appears.
Why does Compile Error in Hidden Module in Excel Appear?
Microsoft is upgrading Office 2016 from 32-bit version to 64-bit version. This Compile Error in Hidden module error message usually appears when there are dome 32-bit add-ins versions of office which are incompatible with the newer version.
The most common reason behind this error is when some conditions come true:
1: MS Excel startup folder when contains both the template files on Adobe Acrobat PDF Maker add-in:
Pdfmaker.dot
Pdfmaker.xla
2: Software named Norton Anti-virus software has been installed.
Now, that you know the reason that causes Compile Error in Hidden module in Excel. Let's begin with the solutions to fix this error.
How Do I Fix Compile Error in Hidden Module in Excel?
1: Re-register OCX Files Using CMD
To fix compile error in hidden module you need to re-register some files basic to the functionality of Excel. Follow the steps:
- Start your system with the Administrative rights
- Press Windows + R key
- Type 'cmd' and click on OK
- Depending on the version type the following commands and press enter:
For 32-bit version
regsvr32 -u c:windowssystem32mscomctl.ocx
regsvr32 c:windowssystem32mscomctl.ocx
For 64-bit version
regsvr32 -u c:windowssyswow64mscomctl.ocx
regsvr32 c:windowssyswow64mscomctl.ocx
Compile Error In Hidden Module Excel 2013
Now, run MS Excel and see whether Microsoft visual basic compile error in hidden module is solved or not.
2: Try Deleting .exd Files
If the above-given solution did nor work then try deleting the .exd files from your folder, this might help you in fixing the compile error in hidden module in excel. Follow the steps to delete files:
- Press Windows + R key
- Type %appdata% and click OK
- This will open the Application Data folder, now select Microsoft
- Open the Forms folder
- Select comctllib.exd and mscomctllib.exd, Right-click on them and Delete
Deleting the .exd files will let you start Excel and the compile error in hidden module issue will be resolved.
3: Move PDF Maker Files
If you are using Adobe Acrobat PDF Maker then to solve this issue you need to move the Pdfmaker.dot file and Pdfmaker.xla files to a different location. To do so follow the steps given below:
How Do I Fix Compile Error in Hidden Module in Excel?
1: Re-register OCX Files Using CMD
To fix compile error in hidden module you need to re-register some files basic to the functionality of Excel. Follow the steps:
- Start your system with the Administrative rights
- Press Windows + R key
- Type 'cmd' and click on OK
- Depending on the version type the following commands and press enter:
For 32-bit version
regsvr32 -u c:windowssystem32mscomctl.ocx
regsvr32 c:windowssystem32mscomctl.ocx
For 64-bit version
regsvr32 -u c:windowssyswow64mscomctl.ocx
regsvr32 c:windowssyswow64mscomctl.ocx
Compile Error In Hidden Module Excel 2013
Now, run MS Excel and see whether Microsoft visual basic compile error in hidden module is solved or not.
2: Try Deleting .exd Files
If the above-given solution did nor work then try deleting the .exd files from your folder, this might help you in fixing the compile error in hidden module in excel. Follow the steps to delete files:
- Press Windows + R key
- Type %appdata% and click OK
- This will open the Application Data folder, now select Microsoft
- Open the Forms folder
- Select comctllib.exd and mscomctllib.exd, Right-click on them and Delete
Deleting the .exd files will let you start Excel and the compile error in hidden module issue will be resolved.
3: Move PDF Maker Files
If you are using Adobe Acrobat PDF Maker then to solve this issue you need to move the Pdfmaker.dot file and Pdfmaker.xla files to a different location. To do so follow the steps given below:
- Click on the Windows icon and type pdfmaker. *
- Click on all files and folders.
- In the All or part of the file name type pdfmaker. *and search
- Once the files are located, right-click on the pdfmaker.dot & pdfmaker.xla, and select the Cut.
- Go to the Desktop and Paste it
After moving the PDF files by performing the above-stated steps compile error in hidden module excel issue must be solved.
4: Update Latest Version of Adobe Acrobat
If the above method mentioned didn't fix the ExcelCompile error in hidden module 2016 problem, then you can try updating the Adobe Acrobat version.
To update the add-in Adobe Acrobat, visit the official website of Adobe. You can find the newest updates in the search engine by searching the Adobe Acrobat Updates.
After updating the Adobe Acrobat restart your system and see if the compile error in hidden module excel problem is solved or not.
5: Fix 'Compile error in hidden module' Module 1
This error also occurs when you have recently upgraded or might have saved an Excel file that was created in different location between versions.
To fix this issue follow the simple steps mentioned below:
- Select the file that is wrongly saved in Excel
- Press Alt+ F11 to go into the file Visual Basic Editor.
- From the Tools menu, select the References
- Scroll down to the Available References box and uncheck all that starts with MISSING:
- Press Alt+ Q when all the reference errors have been unchecked.
These steps will help you to fix compile error in hidden module 1 issue.
Automatic Solution: MS Excel Repair Tool
If you are finding the above solutions difficult in performing and are unable to solve compile error in hidden module excel issue, then you can try running MS Excel Repair Tool.
This is an advanced repairing tool that not only repairs damaged, corrupted or inaccessible Excel files and all sorts of Excel errors but also recovers deleted, lost data from chart sheet, cell comment, formula & others.
One can easily use this tool without the need for any professional and it supports all Excel versions.
Steps to Utilize MS Excel Repair Tool:
Conclusion
So, this was all about Compile Error in Hidden Module Excel. Well, I have tried my best to put together all the working solutions together to fix this issue.
Carefully follow the solutions given one by one. They are easy to use and had worked for many users.
Xming-portable putty-x64. Putty and Xming are easy to set up on your laptop. The alternative is to use Linux on your laptop, either in dual boot mode or in a virtual setup. If you have a Mac you can use the terminal application. If you are off-campus, you need to use UCI's VPN Service in order.
Hope you liked this article and it worked for you in fixing the compile error in hidden module excel issue and making your Excel work again without any error.
Apart from this if you have any suggestions or queries then feel free to share it with us in the below comment section.
Margret
Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.
Mac Excel Compile Error In Hidden Module
- Points
- 8
- Trophies
- 1
- Posts
- 2
Hi all,
Thanks for having me here. I get the error message 'Compile Error In Hidden Module: Thisworkbook' every time i start excel 2007. I've only installed it recently and only settings I have changed in excel is install the add-ins solver and data analysis. I've also had Nitro PDF 5 Pro installed before Office 2007 was installed. I have recently uninstalled Nitro PDF5.
The running costs are not huge but could become more significant in the future so any donations to show appreciation would be amazing. I would like to emphasise MyRecordList was created for the love, not the money so kind words and likes/shares are just as appreciated too if you can't spare any cash - we hope you enjoy the site! Ahmad jamal genetic walk zip 2. Support UsWe understand how frustrating advertising can be and the only nagging message you will see is this note asking you to kindly donate whatever you can afford if you use the site regularly or would just like to support a small independent project created for the love of music and record collections.
I'm not a coder and so I havent messed around with marcos etc. How do I get rid of this issue in excel 2007?
- Navigation
- OzGrid
- Forum
- Members
- Options
- Current Location
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.
