Optimize Performance for Large Models in OfficeConnect
Workday OfficeConnect reports can slow down significantly when workbooks contain hundreds of formulas pulling from large Adaptive Planning models. Refresh times of 30–60 seconds are common in unoptimized workbooks; the techniques below typically cut that to under 10 seconds for the same data.
What you’ll need:
- Workday OfficeConnect connected to an Adaptive Planning tenant
- A workbook that is currently slow to refresh (more than 15 seconds)
The single biggest performance factor is formula count. Each OfficeConnect formula is a separate server call during refresh.
- Use rollup accounts instead of leaf accounts. If you’re reporting on 50 leaf-level expense accounts when a single “Total Operating Expenses” rollup account would suffice, replace them. One rollup formula = one server call instead of 50.
- Delete unused rows and columns. Workbooks accumulate leftover OfficeConnect formulas in hidden rows or off-screen columns. Select unused areas, delete the cells entirely (not just clear contents), and save.
- Consolidate time contexts. If every data cell has its own Time element, replace them with a single Time element in the header row that all data cells reference. OfficeConnect reads the shared element rather than re-querying time for each cell.
A report showing 24 monthly columns (2 years of months) makes many more server calls than a report showing 8 quarterly columns covering the same period. If your use case allows quarterly or annual granularity, switch to it — refresh time drops proportionally.
For trend reports that must show months, consider building two separate sheets: a summary sheet with quarterly data (fast refresh, for sharing) and a detail sheet with monthly data (slower, used only when drilling in).
NOW(), TODAY(), RAND(), and OFFSET() recalculate on every keystroke, which can trigger OfficeConnect recalculations repeatedly. Move these functions to a separate sheet, or replace them with static values where possible.Tip: Use the Cell Explorer (OfficeConnect ribbon → Cell Explorer) to inspect any slow-refreshing cell. It shows exactly which elements the formula is querying — account, version, time, level, and dimensions. This is the fastest way to spot an unexpectedly broad query.
Workday OfficeConnect refresh performance is partly determined by Adaptive Planning server response time. If refresh is slow even on a simple workbook, check:
- Whether other users are running large reports or processes on the tenant at the same time (peak usage hours are slower)
- Your network connection to Workday’s servers (VPN can add latency)
- Whether your Adaptive Planning model has recently been optimized (contact your admin)
Result
A workbook that previously took 30-60 seconds to refresh should now complete in under 10 seconds with these techniques applied.
Next steps
- Fix Slow Performance in Large Reports — if you’re still seeing slowness after these changes.
- Cell Explorer / Drill Down — find the cells driving slow refresh.
- Filter Data — scope reports for faster queries.