Cell Explorer & Drill-Down
When a number in your Workday OfficeConnect report looks unexpected, Explore Cell lets you drill into the contributing details to find the source. It pairs naturally with Review & Verify Applied Elements — Review shows which elements drive a cell, while Explore Cell shows the underlying data behind the result.
What Explore Cell shows
For any cell with data, Explore Cell reveals:
| Detail | Description |
|---|---|
| Contributing rows | The specific data intersections driving the value |
| Account details | Rollup values and links to child accounts |
| Level details | Rollup values and links to child levels |
| Time details | Breakdown by time period |
| Audit trail | Change history (if Audit Trail is enabled in Adaptive Planning) |
| Other sheets | Links to other sheets that show the same value |
| Source drills | Drill into Transactions, Workday objects, or NetSuite (if configured) |
Note: Explore Cell applies to the Adaptive Planning data source. For the Financials data source, use Show Details instead, which shows contributing journal line and plan line details.
Steps
Zeros and blanks in Explore Cell
Explore Cell automatically suppresses rows with all zeros or blanks by default — only rows that actually contribute to the value are shown. To see zero rows:
Note: This setting resets each time you launch Explore Cell.
Show Details (Financials data source)
For Financials data source users, Show Details is the equivalent feature:
For large worksheets, Show Details performs better with 64-bit Excel.
Next steps
- Drill Through to Workday Journal Lines for the Financials-data-source equivalent
- Review & Verify Applied Elements to confirm the elements driving a cell
- Fix Data Discrepancies Between OfficeConnect and Workday when the drill-down reveals an unexpected variance