Troubleshoot & FAQ

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

Articles in this section

• COM Registration Error — How to resolve COM registration errors when installing or updating OfficeConnect
• Update Errors — How to fix errors that occur when updating OfficeConnect to a new version
• Task Pane Issues — How to fix the OfficeConnect Reporting pane when it’s not showing or displaying incorrectly
• Numbers Not Shifting — Why OfficeConnect elements don’t move when you insert Excel rows, and how to fix it
• Hide Zeros & 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
• Rounding Settings — How to change how numbers are rounded in OfficeConnect reports
• Percentage Values — How to prevent rounding from distorting percentage values in OfficeConnect
• Fixed Date Columns — How to prevent date columns from rolling forward when using relative time elements
• Trailing 12-Month Report — How to build a report that always shows the most recent 12 months of data
• Link External Excel Files — How to link to a plain Excel file from within an OfficeConnect workbook
• Troubleshooting Tool — How to use the OCSystemChecker tool to generate a diagnostic log for Workday Support
• Re-Enable Disabled COM Add-in — If Excel disabled Workday OfficeConnect after a crash or stall, the ribbon tab disappears and reinstalling doesn’t help — re-enable it from Excel’s Disabled Items list
• ‘Contact Technical Support’ on Refresh — The vague “Refresh failed — contact technical support” dialog in Workday OfficeConnect almost always has one of five concrete causes. Diagnose and fix
• Not Refreshing — OfficeConnect shows stale data or the Refresh button does nothing — causes and step-by-step fixes
• Authentication and Token Errors — OfficeConnect shows authentication errors, token expired messages, or fails to sign in — causes and step-by-step fixes for SSO and token issues
• Slow Performance — OfficeConnect refresh takes a long time in large workbooks — diagnose the cause and reduce refresh time
• Data Discrepancies — OfficeConnect shows different figures than Workday Report Writer or the Workday UI for the same account and period — common causes and how to diagnose them
• think-cell Conflict — Workday OfficeConnect and think-cell both use Excel COM subclassing and can interfere with each other — refresh failures, broken charts, Excel crashes. Here’s the documented fix
• OfficeConnect on Mac — Install and use Workday OfficeConnect on a Mac with Excel for Mac — what works, what’s different from Windows, and how to handle common Mac-specific issues
• Mac VDI Workflow — Mac users can run the full Windows OfficeConnect experience through a VDI like Azure Virtual Desktop, AWS WorkSpaces, or Parallels — here’s the realistic decision guide and setup