Extend the Security rights of the Merlin Admin User by giving it the role "Shared Services - Financial Management Manager
Compile error in hidden module
Applies to versions of MerlinXL designed to run on Excel 2003. Error Message When opening older versions of MerlinXL in a 64 bit OS you see the error message: Compile error in hidden module Example Error Message Cause This error is generally caused by an out of date version of...
How to fix Excel as a result of the Microsoft Security Updates (Pre Excel 2013)
Answer: There have been 2 Microsoft Security updates that have caused problems with Excel. The steps we have found to fix the problems casued by these Security Updates are: 1. If Excel 2007 run the Excel Diagnostics Ensure Excel is closed before steps 2 & 3 2. Remove the *.exd files (temp...
Cannot run the macro C:\…..! CellMenuDrillAction when I right-click in a report
Answer We recommend reinstalling Excel
Could not load an object because it is not available on this machine.
Answer This error is as a result of Microsoft security update MS27-027 released May 2012. Unfortunately this update does not correctly update certain Office dll files, mainly MSCOMCTL.OCX which is used by Excel to display controls on the forms, for example the treeview control used to display the list of...
Compile error in hidden module
The error may also say This Module instead of frmTreeView Answer This is related to the Microsoft Security Update MS12-027. Delete “.EXD” files in the local drive, C:\ Open the command prompt Navigate to Documents and Settings (or Users on Windows 7) C:\Documents and Settings> del/S/A:H/A:-H *.EXD (and press enter key) Depending...
Automation error
Answer This error is as a result of Microsoft Security update MS12-060 released August 2012 This update has caused a problem with an Office dll file MSCOMCTL.OCX used by Excel to display controls in forms. Solution Re-register the MSCOMCTL.OCX file. 1. Open the Command Prompt (DOS Window) with admin rights...