While using MS Excel are you getting error messages “Can’t insert object”? Are you unable to access or change the properties of any active controls on worksheets? Or while you are trying to refer ActiveX Control as a member of a worksheet, you are getting error 438? Then this article is for you. Undoubtedly Excel is very important and high;y used application of Microsoft Office suite.
Nov 11, 2015 - Respected Experts, I am not able to run the following Macro in Excel in Mac computer. I am getting Runtime Error 429 - ActiveX Component.
But in many cases, this start showing various errors or gets easily corrupted. Today in this article I am going to describe how to fix Microsoft Excel ActiveX controls issues or repair broken ActiveX controls in Excel. This is comm0only faced due to the issue with the update of the ActiveX Control patch in Excel. You may be thinking if your Excel file is working properly, and then what is the need for this update. These updates are necessary because it keeps your Excel file updated and helps in performing better. If after installing the updated patch, you are facing a problem, then it can be fixed by following the steps mentioned in this article. Causes Of Excel File Corruption MS Excel is capable of serving the users who want to keep their record.
With the use of its mathematical formula users are able to perform a very small to large calculations very easily. However, this Excel file sometimes might become corrupted. Let us have a look at some common scenarios. Virus Infection: One of the most common reasons for the corruption of Excel file is the virus infection.
A computer virus is a malicious program that is designed in a way that they corrupt file system of your computer or it may damage some saved files as well. If your computer is infected with any such kind of virus then the chances of corruption become higher. Improper System Shutdown: Sometimes, your excel file may also become corrupted due to improper system shutdown. However, sometimes reasons like sudden power cut or due to any other reason your computer turns off suddenly and the chances to open MS Excel sheet Closes all the opened files improperly during the shutdown. Large Size of Excel File: MS Excel file is not a database that can handle and manage a large amount of information.
So, if your Excel file is too large in size then the chances of corruption is possible. Generation of bad sectors on your data storage device: Some of the data storage devices like external hard drive, local hard drive, pen drive, etc can develop bad sectors.
If you have saved your Excel sheet in the bad sector then it may get corrupted. MS Excel application issues: MS Excel application issues like an unexpected closing of an open Excel sheet or improper closing of an opened file can corrupt MS Excel file. Further Reading:. How to Repair Broken ActiveX Controls in Microsoft Excel #1: Search the EMD Files.
Close all the Office applications. In Windows Explorer, you have to search for all.emd files, while doing so, make sure that you have included all hidden system files and folders, and erase the.emd files. This file would generally be displayed in the following ways: C: users username AppData Local Temp Excel8.0 MSForms.exd C: users username AppData Local Temp VBE MSForms.exd. After erasing the file restart your PC. Now open the Office apps and test its controls.
You must remember that when you would open your workbook with embedded active control, the.exd files be recreated created again, but it would not cause any issues. In this way, the Excel VBA ActiveX controls problem would be resolved. If still, the problem exists, then it can be fixed with the help of third party application software. #2: Recover Data from Temp Files It is recommended that apply manual repair method to fix Excel corruption and if you get unsuccessful then go with any other repair tool. Apply the below-given carefully to recover data from corrupted Excel file. At very first close MS Excel application and re-open it.
Try to open the affected file. If you are unable to open the affected file then, reboot your computer and open MS Excel. Try to open the file again. If you are still unable to open the file then, delete the contents of your C: windows temp directory then restart your computer.
Try to open the affected file. If the affected file is still inaccessible then apply the below-given trick:. Click on the Start button Open run dialogue box and type-. “C: Program Files Microsoft Office Office excel.exe” /s. After it, try to open the file again Are you unable to open the file again?
If YES, then it is suggested to scan the file for possible virus infection. Make sure that your macro heuristics scanning option is set to ON. After completion of the scan if no virus has been found then, rename the file name and replace the.xls extension with the.doc extension. After it, try to open the file with Word.
My client has a product based on Excel spreadsheets (2003- compatible) that we are porting to the Mac targeting Office 2011. These files using a significant amount of VBA code to check for valid licenses, perform functions, etc. We have been using.xls files but find that there are a number of problems with compatibility, including.xls files that compile fine on the PC but blow up when transported to the MAC due to subtle differences between the two, that I have been unable to code around (so far). It was suggested that we using either.xlsm format or.xlsb format rather than.xls to work around these problems and reduce file sizes. This turns out not to work very well as we are using an ActiveX image control to 'veil' sheets in the workbook until the license is verified.
This works fine in the ported.xls file, but immediately causes an error in the.xlsm and.xlsb format with the message that 'ActiveX is not supported and the workbook will now be read-only'. The VBA code proceeds to happily check the license, hide the ActiveX image 'veil' (that Excel just claimed was not supported) and display the sheet.
The veil is used because MAC users have the option of turning off Macros, which means that any active means of preventing a user from seeing the content won't work. The passive mechanism ensures that they turn on Macros and pass a license check before they see any content. Is there any other way of putting an image in front of the content on the spreadsheet that does not involve Macros? Preferably, how do we get the ActiveX image, which works fine with.xls format to work with.xlsm or.xlsb and to turn off the bogus Read Only message?
All suggestions welcome. Thanks, Neil.