Skip to Content
0
Former Member
Sep 16, 2011 at 05:11 PM

How to Diagnose Microsoft Office Automation for conflicts with Xcelsius

43 Views

When designing a Dashboard, there may be times when Excel errors will prevent you from using the Dashboards (Xcelsius) client tool. These issues typically include errors such as "Excel is Busy" or problems accessing Microsoft Excel while attempting to run Dashboards (Xcelsius).

Cause

Dashboards (Xcelsius) uses the Microsoft Office Automation libraries to interact with Excel, Word, PowerPoint, and Outlook. Likewise, third-party Office Add-ins also use these same libraries to function, which can possibly cause conflicts when using Dashboards.

Solution

Any conflicting Office Add-ins will need to be disabled while Xcelsius is in use. In some occasions, these Add-ins must be un-installed to be fully disabled. The OACheck.exe is a Microsoft diagnostic tool that will help test the health of the Automation Libraries and will also detect all Add-ins that might not be visible inside the Excel Options>Add-ins Menu.

Attached is a copy of Microsoft's OACheck.exe diagnostic tool along with step-by-step instructions. Rename the extension from .txt to .zip.

Edited by: Jon Teopaco on Sep 23, 2011 6:17 PM

Edited by: Jon Teopaco on Sep 24, 2011 1:57 AM