Work with Time & Contexts
Add time periods to your report and use contexts like YTD, QTD, and Beginning Balance.
Tag: How-To
Filter Your Data
Apply worksheet and workbook filters to limit which data appears in your report.
Set Up Your Reporting Model
Use the Run Set Up Reporting Model task in Workday to configure how OfficeConnect Financials reports are structured.
Cut, Copy & Move Elements
How to move OfficeConnect elements within and between rows, columns, and cells.
Use Effective Date Reporting After a Reorganization
Use OfficeConnect’s effective date setting to report against your organization’s structure as it existed on a specific date — essential after a reorganization.
Check & Update Your Version.
How to check which version of OfficeConnect you have and update to the latest release.
Filter Reports by Company in OfficeConnect (Financials)
Scope an OfficeConnect Financials report to a specific legal entity, or build a multi-company view showing each entity in its own column.
Review & Verify Applied Elements
Use the Review tab to see exactly which elements are affecting any cell, row, or column.
Multi-Currency Reporting with the Financials Data Source
Report in your chosen currency using Workday Financial Management’s currency conversion — select transaction currency, company currency, or a converted reporting currency in OfficeConnect.
Cell Explorer & Drill-Down
Explore the data behind any cell to understand what’s driving the numbers.
Optimize Performance for Large Models in OfficeConnect
Speed up Workday OfficeConnect reports that are slow to refresh — reduce formula count, use efficient time contexts, and configure workbook settings for large Adaptive Planning models.
Secure OfficeConnect Workbooks
How Workday OfficeConnect handles security, timeouts, and data clearing to protect sensitive financial data.
Share Reports via Teams, SharePoint & OneDrive
Save and share Workday OfficeConnect workbooks through Microsoft Teams, SharePoint, or OneDrive.
Report on Worktag Combinations in OfficeConnect
Build reports that slice GL actuals by multiple Workday worktags simultaneously — Cost Center and Fund, or Cost Center and Project — using OfficeConnect’s dimension filters.
Work with Multiple Instances
How to switch between production, sandbox, and multi-instances in Workday OfficeConnect.
Compare Two Planning Versions Side by Side
Add a second version column to any OfficeConnect report to compare Budget vs. Forecast, two plan iterations, or any two Adaptive Planning versions.
Lock and Protect Reports for Distribution
Protect an OfficeConnect workbook for distribution so recipients can’t accidentally break formulas — while keeping Refresh working.
Report in Constant Currency in OfficeConnect
Use a constant currency version in Adaptive Planning to remove FX impact from OfficeConnect reports — useful for multinational teams comparing performance across periods.
32-bit vs 64-bit Excel for Workday OfficeConnect
Why 64-bit Excel matters for large Workday OfficeConnect workbooks, how to check which version you’re running, and how to switch without breaking other add-ins.
Use 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.
Refreshing All Slides Safely in a Workday OfficeConnect PowerPoint Deck
The disciplined refresh workflow that keeps Workday OfficeConnect PowerPoint decks consistent — never a deck with mixed-period numbers.
Designing Write-Back Permissions for Workday OfficeConnect
Design Adaptive Planning permissions so Workday OfficeConnect write-back is safe by default — least-privilege roles, version-state gates, and Level-scoped assignments.
Work with Custom Dimensions and Attributes in OfficeConnect
Report on custom dimensions and attributes defined in your Adaptive Planning model — filter by product line, region, project, or any other custom segment your team uses.
Workday OfficeConnect on Mac: The 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.
Recovering Broken Links in a Workday OfficeConnect PowerPoint Deck
When a Workday OfficeConnect PowerPoint link breaks — file moved, named range renamed, workbook deleted — here are the fix paths in order of cost.
How to Reduce OfficeConnect Element Count for Faster Refresh
Element count is the single biggest performance lever in Workday OfficeConnect — five concrete tactics to cut it without losing the report you need.
Single Sign-On for Workday OfficeConnect with Okta
Configure Okta to authenticate Workday OfficeConnect users via Workday SSO — application setup, claim mapping, MFA pairing, and the common failure modes.
Deploy Tenants via Registry
Push Workday OfficeConnect tenant configuration to user machines using the Windows registry.
Workday OfficeConnect Patterns for Large Repeating Reports
Patterns and pitfalls for Workday OfficeConnect reports that use repeating rows to generate hundreds of lines from a single element.
PowerPoint Charts That Update with the Period in Workday OfficeConnect
Build PowerPoint charts whose axes, titles, and data ranges update automatically when the reporting period rolls — no more re-creating the trend chart every month.
Single Sign-On for Workday OfficeConnect with Microsoft Entra ID
Configure Microsoft Entra ID (formerly Azure AD) to authenticate Workday OfficeConnect users via Workday SSO — enterprise application setup, claim mapping, and Conditional Access tuning.
Silent Install Workday OfficeConnect with Microsoft Intune (Win32 App)
Package Workday OfficeConnect as a Win32 app for Microsoft Intune, push to all users silently, and verify deployment.
Silent Install Workday OfficeConnect with SCCM / MECM
Deploy Workday OfficeConnect through Microsoft Configuration Manager (SCCM/MECM) with silent install switches, detection methods, and required user-rights handling.
Refresh Reports Automatically with Power Automate
Use Power Automate Desktop to schedule Workday OfficeConnect report refreshes automatically — keep distributed Excel reports up to date without manual intervention.