Audience: Planners who enter data on sheets.
The cells on your sheet may be gray (read-only). Troubleshoot the sheet to get editable cells.
Before You Begin
How You Get There
See Find and Open Sheets.
Do You Have Permission to Edit?
Check your permissions with your admin. You can't edit data if you:
- Have the Access Sheets permission without the Editable Sheet Access permission.
- Don't have the Access Salary Detail permission and the sheet, account, or cell has salary data.
Is the Version Locked?
Choose a version that isn't locked. If the version is locked or locked through a defined period, you can't edit the data.
Have You Selected Leaf-Level Accounts, Levels, and Dimensions?
- For all sheets: Expand the rows until they can't be expanded.
- For modeled and standard sheets: From the drop-down in the toolbar, choose a level (or an account) without sub-levels or sub-accounts. 1 Levels and accounts with sub-levels have an expand/collapse icon, and 2 levels and accounts without sub-levels do not.
- For cube sheets only: From each dimension filter along the top of the sheet, choose a value that can't be expanded. Look for filters with a dimension icon: .
Are You Looking at Actuals Overlay?
If the font is green in a cell and you're in a planning version, you're looking at actuals data that can't be edited in a planning version. Go to the actuals version for the time period and edit the data.
Is the Data a Formula?
If the cell has a purple triangle and it's gray, the value is calculated from data entered in other accounts. Click in the cell and look at the formula bar to see the account being referenced in the formula:
If you have access to that account in another sheet, edit the source data.
Is the Account Linked?
Linked accounts pull data from another account and are read-only. Edit the data in the source account: Right-click > Cell Explorer. Click the linked account. From that Cell Explorer window, click the sheet where you may be able to edit the data.
Is it a Modeled Sheet With No Records
It looks like you can't edit a modeled sheet that has no records:
To get started, click Add Row from the toolbar and enter or paste the data.
Is it a Modeled or Cube Account on a Standard Sheet?
Modeled or cube accounts on standard sheets are read-only. Go to the account's modeled or cube sheet to edit the source data: Right-click > Cell Explore, and then click the account's modeled or cube sheet.
Are Zeroes and Blanks Suppressed?
If zeros and blank rows are suppressed, try showing them. Go to Display Options . At the bottom of the window, uncheck the Suppress rows if all zeros or blanks.
If it's a cube sheet that is too large to show all suppressed rows, click Add Row and choose dimensions to reveal specific rows.
Does Your Standard Sheet have Mixed Time Configurations?
Standard sheets with accounts that have different time configurations show the largest common time period. Accounts with smaller time periods show read-only time rollups. To edit the smaller time periods, right-click on the account row and select View by Level. The columns display the smaller time period data by level for the account.
Does Your Instance Use Workflow?
You can't edit the data of levels that have been submitted for approval or that have been approved using Workflow. Talk to the person who approves the workflow process. They can reject the level so that the sheet is once again editable.