Writeback lets you either permanently edit model values (if the administrator has permitted it) or run simple “what-if” analyses in Excel.

Anaplan XL Reporting supports writeback through: Grids, Freeform reports, Formula-based reports, and Relational writeback. In each case, you must enable writeback on the data source itself. You must also enable writeback for the report or workbook. Once writeback is enabled, the Writes icon is available on the Grid menu. 

To enable writeback on an Anaplan XL Grid or Freeform report, right-click the grid or report, select Anaplan XL > Properties... > Writeback > Enable Writeback. 

You can also adjust a few other options on this tab:

  • Cells must be unlocked: When checked, you can write back only to cells that are unlocked in the worksheet. This protects against accidental writes.
  • Write to DataMembers in parent-child hierarchies: When checked, writes are directed to the data member of a parent-child hierarchy node rather than the consolidation level.
  • Batch writes together: When checked, multiple cell writes are grouped and submitted as a single batch operation. This can improve performance.

With Automatic mode, Anaplan XL submits each value to the model as you type it. The system writes the value and, optionally, retrieves the data again so that any aggregated data updates right away in the report. This option isn't typically used because you may accidentally overwrite data.

With On request mode, you can enter multiple updates at once and submit them in a single batch. Use this option to submit all pending changes to an Anaplan model once connectivity is restored. 

To view the updates ready to send to the server, right-click and select Anaplan XL > Writeback > Manage Writeback.... This opens the Writeback pane in the workbook. You can also select Grid > Writes > Task pane to open the Writeback pane. To upload the changes, right-click and select Anaplan XL > Writeback > Submit Outstanding Writes. 

You can choose to postpone scanning while editing writable cells. When you request a scan or submission, the operation runs in the background, keeping Excel interactive. This lets you keep working in Excel while scanning and submission run in the background. The Submit All runs a scan when you enable Defer scanning.

You can set the refresh behavior to:

OptionDescription
Don't refresh after writeThe data won't refresh after updating cells. If you don't select Refresh data after write, you can manually refresh the data to view the updates.
Refresh data after writeThis will refresh the data but won't highlight the updated cells.
Refresh data, highlight written cells This is the default value. This refreshes the data and then highlights the updated cells.
Never refresh data areaThe data will never refresh. If you don't refresh the data, you can manually refresh it to view updates. When in On request mode, this is used for Grids and Freeform reports to ensure Excel formula retention. 

By default, Anaplan XL allows entry only at the data leaf level, since this is the most common environment. To permit data entry at any level, right-click and select Anaplan XL > Properties... > Writeback and in the Allow at section, select Any level. 

You must choose from one of four Analysis Services spreading methods from the dropdown:

MethodDescription
Equal allocationAssigns each constituent cell an equal value.
Equal incrementChanges each constituent cell by an incremental value.
Weighted allocationAssigns each constituent cell an equal value, weighted according to a formula.
Weighted incrementChanges each constituent cell incrementally, according to a weighting formula.

You can then enter data at aggregate levels in the model, and the system distributes it according to the rule you specified.

Use non-leaf writeback carefully in an Analysis Services environment, as it can take time depending on cube size and dimensionality.

Review Writeback formatting, cell locking, and data validation for details on locking grid cells and using writeback validation rules.

Review Writeback and grid calculations for details on using Excel formulas to update the database.

Two Anaplan XL formulas handle Analysis Services writeback: XL3DoWriteback and XL3LookupRW.

XL3DoWriteback writes a value from another cell back to the model. With XL3LookupRW, the formula itself overwrites the value directly.

Usually, XL3DoWriteback offers more flexibility and control.

You can also use the XL3RunSQL formula for relational SQL updates. To use formula-based writeback, go to Anaplan XL > Options > Workbook Options... > Writeback, and select Enable data entry mode. 

In Anaplan XL > Options > Workbook Options... > Writeback, you can specify whether to use Standard writeback (Analysis Services), Relational writeback, or REST writeback. Relational writeback requires specific model customizations and is typically a consultancy-led process to provide additional flexibility or performance beyond standard writeback processing.

Also see Relational writeback in Anaplan XL Reporting and Anaplan XL Reporting guardrails.

The Writeback pane is a side panel in Anaplan XL Reporting that tracks cell-level data changes in a worksheet or grid. It lets you review, change, and submit the data modified back to a data source. It updates as you change data in the worksheet or grid. 

The Writeback pane displays, by worksheet and grid, multiple data changes during an Excel session and shows a running count of pending changes, each with its previous and current values.

You can use the Writeback pane to:

  • View the member intersection or delete a value by selecting the ellipsis next to a row. 
  • Display a warning for each input where another user has changed the original value. 
  • Modify the data in a cell within the pane by double-clicking a Current cell of a row and changing the value. 
  • Delete individual cells by selecting the row checkboxes and choosing Delete... > Delete Selected. 
  • Delete all data changes by selecting Delete... > Delete All.
  • Submit individual cells by selecting the row checkboxes and choosing Submit... > Submit Selected. 
  • Submit all data changes by selecting Submit... > Submit All. Submit All runs a scan before submitting when Deferred scanning is enabled.
  • Refresh the data in the Writeback pane. Select Refresh to update the Previous and Current columns. 

The grid or report calculates and highlights parent data. After you refresh the data, the highlighting is removed. 

A warning appears for each input where another user changed the original value. You can then choose whether to resubmit or discard the changed values.

There are different methods to access the Writeback pane after enabling writeback:

  • Go to Anaplan XL > ... More > Writeback.
  • Right-click a grid or report, go to Anaplan XL > Writeback > Manage Workbook. 
  • Go to the Grid menu and select Writes > Task pane. 

Note: Selecting Enable data entry mode in the Writeback tab under Workbook options disables the Writeback pane.


AnaplanXL Reporting doesn’t change, modify, or circumvent your existing security settings. Anaplan XL uses the user’s permission to access the data. This will have the same read and write permissions as set in your data source. 

For more information, review the Anaplan Grid Writeback video.