Interface Tour: The Reporting Pane
A quick tour of the OfficeConnect interface in Excel — the ribbon tab and the Reporting pane.
Tag: Reference
What is OfficeConnect?
An overview of OfficeConnect — what it does, who it’s for, and how it works with Workday Adaptive Planning.
System Requirements
Hardware and software prerequisites before installing OfficeConnect.
Workbook & Worksheet Properties
Configure rounding, data clearing, filters, and display options for your reports.
Deploy
Install Workday OfficeConnect across the organization — silent install switches, Intune Win32 packaging, SCCM, GPO templates, and the per-user vs per-machine decision.
Workday OfficeConnect Glossary
Alphabetical reference for every Workday OfficeConnect term — elements, filters, contexts, write-back, tenants, and more.
PowerPoint board books
Build PowerPoint board books and presentation decks that refresh from your Workday OfficeConnect Excel workbook.
Wiki
Install OfficeConnect and connect to Workday Adaptive Planning from Excel, Word, or PowerPoint.
Build Reports
Add elements, apply filters, and build live Excel reports from your Workday Adaptive Planning data.
Configure
Configure Workday OfficeConnect tenants, single sign-on, multi-instance setups, and network access.
Financials Data Source
Build OfficeConnect reports against Workday Financial Management (GL actuals) — for accounting teams reporting on posted transactions.
Workday OfficeConnect Refresh Time Benchmarks
Rough benchmarks for what a normal Workday OfficeConnect refresh should take by formula count, what moves the numbers, and how to measure your own workbooks.
Word reports & narratives
Build Word documents — board narratives, MD&A drafts, investor letters — with named ranges from your Workday OfficeConnect workbook.
Element Types Reference
Every element type you can drag from the Workday OfficeConnect Reporting pane, what it represents, and where it lives in each data source.
Govern
Govern Workday OfficeConnect responsibly — secure workbooks, manage licenses, rotate secrets, capture audit trails, and run tenant migrations safely.
Sharing your work
Share Workday OfficeConnect workbooks and linked decks via Microsoft Teams, SharePoint, and OneDrive — including co-authoring caveats and recipient permissions.
Word & PowerPoint
Link Workday OfficeConnect data into Word documents and PowerPoint slides for board books, narrative reports, and presentation-ready decks.
Data Entry & Write-Back
Enter budget and forecast data, and write back to Workday Adaptive Planning directly from Excel using OfficeConnect (2025R1+).
Upgrade
Manage Workday OfficeConnect’s forced-upgrade cadence — version compatibility, user preparation, rollback paths, and multi-region migrations.
Workday OfficeConnect Version Compatibility Matrix
Which Workday OfficeConnect client versions work with which Workday Adaptive Planning releases — including the forced-upgrade grace periods.
System Admins
Deploy, configure, govern, and optimize Workday OfficeConnect — for IT administrators and the system-savvy FP&A power users who own the platform.
Troubleshoot & FAQ
Fix common OfficeConnect errors and get answers to frequently asked questions.
Auditing Workday OfficeConnect Write-Back Submissions
Where Workday OfficeConnect write-back submissions are logged in Adaptive Planning, what’s captured, and how to build a SOX-grade review process around the audit trail.
Performance & Optimization
Make Workday OfficeConnect reports fast — refresh-time benchmarks, 32-bit vs 64-bit Excel, element-count tradeoffs, and large-workbook patterns.
Migration & Comparison
Decision frameworks comparing Workday OfficeConnect to alternatives, plus migration guides from Hyperion SmartView, OneStream, Vena, Anaplan, and macro-heavy Excel workbooks.
Reference
Quick-lookup reference for Workday OfficeConnect — glossary, formula syntax, element types, version compatibility, time tokens, keyboard shortcuts, and network endpoints.
What's New
Workday OfficeConnect release notes hub — 2026R1 (View By, personal what-if scenarios), 2025R2, 2025R1 write-back, and the release archive.
Resources
Downloadable templates, PDF cheat sheets, video library, and a sample tenant dataset for practicing with Workday OfficeConnect.