Workbook Run-Time Troubleshooting Procedure
Conduct workbook run-time troubleshooting to find and resolve common issues that may prevent a compiled workbook from running correctly. If the workbook has been successfully compiled but it does not run, you should check the following reasons in the computer environment that are preventing the compiled workbook from opening or causing the incorrect workbook behavior.
Verify Whether Windows Operating System Has Pending Updates
Please verify whether your Windows operating system has pending updates. If so, please ensure that you complete the Windows OS update first then reboot your computer.
Verify Whether MS Office has latest updates
Please make sure that you have the latest service packs and updates for your version of MS Office.
Workbook Run-time Antivirus Troubleshooting
Antivirus software may hinder the normal behavior of our product. To ensure that our product is working correctly, please temporarily disable your antivirus software. You can then open your compiled workbook after doing so. If the workbook started successfully after disabling the antivirus, then the problem is a false positive detection from the antivirus. To reduce antivirus false positive detections, you need to include the folder where your protected workbook is located into the antivirus exception list.
Troubleshoot that You Have Appropriate Security Permissions for the Run-time Workbook
You may have security permissions that are too low level to save files into or open files from some folders on your computer.
Please copy your protected workbook to the “My Documents” folder (or any of its sub-folders) on your computer. Then, try to open it again.
You can also try running the compiled workbook as an administrator: select the compiled workbook in the Windows Explorer, right-click the file and select “Run as Administrator“. This action will elevate your current user permissions and verify whether the lack of security permissions is the reason of the problem.
Verify preinstalled third-party Excel Add-ins
Some third-party Excel add-ins may block the normal behavior of a compiled workbook. We recommend temporarily removing such Excel add-ins if installed to prevent them from blocking the workbook from opening.
Verify that all required VBA ActiveX components are installed
If your workbook uses ActiveX components in VBA code, this section is important. The absence of these components on the client computer may lead to the incorrect behavior of the compiled workbook. Make sure that all ActiveX components are present in the VBA Editor main menu > Tools > References on the computer where the problem occurs.
If all of the previous troubleshooting approaches don’t fix the problem
If you have tried all above and the problem still persists, then please provide the following information to our support email (support@doneex.com):
- An uncompiled workbook example, in its original format (xls, xlsx, xlsm, xlsb), which leads to the problem after compilation.
- A screenshot of your compilation options.
- A screenshot of the MS Excel About box from the computer where the problem appears.
In order to find the source of the problem we have to reproduce the same situation on our side. Without an example provided by you this is impossible.