How to Diagnose Microsoft Office Automation for conflicts with Xcelsius

[Former Member]

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

[sriramvijay_ravidoss]

Hi Jon,

Thanks for your contribution.

I have suffered this issue many times and lost some of the valuable works. Unfortunately the link you have provided is not working.

This issue happens mostly when we use Bex analyzer and xcelsius side by side, bex usage is also unavoidable.

Thanks ,

Sriramvijay.R