Edit data
You can edit data in an Exploration View that uses an IBM® Planning Analytics data source, if you have Write access to the cells and the cells are editable.
- White: A consolidated cell.
- Gray: A derived or locked cell. You cannot edit the value.
- Green: A calculated cell.
- Dark gray: A cell with a hold applied. Place a hold on a cell to exclude it from data spreading. For more information, see Edit TM1 data by using data spreading.
Planning Analytics for Microsoft Excel offers different ways to work with IBM TM1® data changes. You can determine how your user group is designed to operate based on the options presented on the toolbar. For example, if you have been granted Sandbox capability, you have access to the New Sandbox and Delete Sandbox options. For more information, see Writeback mode and Virtual sandbox dimensions..
To edit a value in a cell, click the cell, type the new value, and then press Enter.
To save your changes, commit the data to the TM1 Server Application folder.
On the IBM Planning
Analytics toolbar, click 
Commit. A confirmation dialog box is displayed.
For more information, see Commit data in a TM1 Exploration View.
- Bold blue font: The value in the cell has changed but has not been committed to the TM1 server.
- Orange background: The value in the cell has been committed to your sandbox, but has not been committed to Base.
After you commit the changes, the Exploration View displays the updated values in a normal font, indicating that you have saved the changes.