Troubleshoot & FAQ

Fix common OfficeConnect errors and get answers to frequently asked questions.

Step-by-step fixes for the most common OfficeConnect issues, from installation errors to display problems and data formatting questions.


Fix COM Registration Errors

How to resolve COM registration errors when installing or updating OfficeConnect.

Resolve OfficeConnect Update Errors

How to fix errors that occur when updating OfficeConnect to a new version.

Task Pane Not Displaying Correctly

How to fix the OfficeConnect Reporting pane when it’s not showing or displaying incorrectly.

Numbers Not Shifting After Inserting Rows

Why OfficeConnect elements don’t move when you insert Excel rows, and how to fix it.

Suppress & Hide Zeros and Blanks

How to hide rows with all zeros or blank values in your OfficeConnect workbook.

Remove Elements

How to clear OfficeConnect elements from cells, rows, or columns.

Change Rounding Settings

How to change how numbers are rounded in OfficeConnect reports.

Display Percentage Values Correctly

How to prevent rounding from distorting percentage values in OfficeConnect.

Create Fixed Date Columns

How to prevent date columns from rolling forward when using relative time elements.

Create a Trailing 12-Month Report

How to build a report that always shows the most recent 12 months of data.

Link to External Excel Files

How to link to a plain Excel file from within an OfficeConnect workbook.

Run the Troubleshooting Tool

How to use the OCSystemChecker tool to generate a diagnostic log for Workday Support.