What it does
Forecast values are pre-aggregated, not calculated live. Three mechanisms keep them current: an immediate delta recalculation for changes made on the Forecasts page, a scheduled full recalculation, and a manual Recalculate data button. Knowing which applies is the difference between explaining a delay and chasing a defect.
Key facts
- Automatic delta recalculation is immediate and covers changes made on the Forecasts page itself — editing an underlying record from the drill-down grid, or adjusting a forecast value. It applies to current, past and annual periods alike.
- Automatic full recalculation runs at end of day for the current period, and end of month for annual periods. It picks up changes made outside the Forecasts page — an opportunity edited on the Opportunities page, or a change to the forecast hierarchy.
- Manual full recalculation is the Recalculate data button on the forecast grid. It is the only way to refresh past periods for anything other than a Forecasts-page edit.
- The daily job only touches the current forecast period. Past periods are never picked up automatically.
- Forecast hierarchy changes — a seller moving to a new manager, a new joiner — apply only after a full recalculation, not on delta.
- Manually adjusted values are not overwritten by any recalculation. They persist until reset.
- The Prediction column is outside all of this. It refreshes on its own seven-day cycle.
- Auto-recalculation only runs while the forecast is in an active state. After the final period lapses it continues for a further 30 days, then stops.
- Simple column data and adjust fields can take up to two hours to show, independent of the recalculation cycle.
- The out-of-the-box forecast updates near real time. Configured forecasts do not — they follow the 24-hour cycle or a manual refresh.
When to use / skip
This is not a feature you switch on, it is behaviour you have to design around, and the design decision is where the client's sellers do their editing.
If sellers update deals from the forecast grid's drill-down, everything is immediate and nobody complains. If they work from the opportunity form, the sales pipeline board or the sales accelerator, the forecast is up to a day behind and every forecast call starts with someone hitting Recalculate data. Neither is wrong, but you should pick one and tell the client which they have.
Where past periods matter — a client who reviews last quarter's forecast accuracy — accept that those numbers are frozen until someone manually recalculates. Build that into the month-end process rather than hoping.
Do not build custom refresh automation. There is no supported trigger for forecast recalculation and the manual button covers the real cases.
Configuration decisions
- Whether sellers edit deals from the forecast drill-down grid or from the opportunity form, since that alone determines whether the forecast feels live.
- Who has access to Recalculate data and whether it is part of a documented process or an ad-hoc habit.
- What happens at period close: a manual recalculation before the numbers are quoted, or acceptance that the last day's activity may be missing.
- How hierarchy changes are handled operationally — a joiner or mover needs a full recalculation before their pipeline appears.
- When a forecast configuration gets deactivated. Leaving old forecasts active burns one of the six active slots and keeps recalculation running for 30 days past the end.
- Whether the client's reporting reads the forecast tables directly, in which case they are reading whatever the last recalculation produced, not live pipeline.
Gotchas
- The single biggest support ticket in forecasting: "I closed the deal and the forecast didn't change." It closed on the Opportunities page, so it will move at end of day. This is expected behaviour, not a bug.
- Past periods never self-correct. A back-dated opportunity edit or a retrospective hierarchy fix stays invisible until someone presses Recalculate data on that period.
- Hierarchy changes are the sharp edge. A new starter added on Monday shows nothing until the overnight full recalculation, and the opportunities they inherit move at the same time — so a manager's number can jump overnight with no obvious cause.
- Adjusted cells are immune to recalculation. If a manager adjusted Committed in week one, no amount of recalculating brings it back to reality.
- The 30-day post-expiry window means a forecast quietly stops updating rather than raising anything. Old configurations left active look fine and are stale.
- The two-hour lag on simple columns and adjust fields is separate from the recalculation cycle, so "I recalculated and it still hasn't changed" is also expected.
Consultant notes
- Put the recalculation timings on one slide in training. It removes most of the "the forecast is wrong" traffic in the first month.
- Show managers the Recalculate data button explicitly and tell them to press it before the forecast call. It is the single most useful thing they can learn about the feature.
- If the client insists the forecast must be live, drive them towards editing from the drill-down grid rather than promising real-time behaviour that does not exist.
- Deactivate forecast configurations you are not using — for the active-slot ceiling, and so nobody reads a stale grid.
- Before go-live, test the full path: change an opportunity on the Opportunities page, confirm nothing moves, recalculate, confirm it does. Do it with the client watching so the behaviour is agreed rather than discovered.
Worth another look if Microsoft shortens the end-of-day cycle or brings past periods into the automatic job.