Skip to main content
Adaptive Insights
Knowledge @ Adaptive Insights LLC, a Workday company.

Get to Editable Cells in Sheets

Explains what to do when all the cells on your sheet appears to be read-only.

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

Compass.png 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.

Loked Versions.png

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.

LevelwithoutSubLevel.png

  • 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: FindDimensions.png.

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:

Account in 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.

Link Account in cell explorer

Is it a Modeled Sheet With No Records

It looks like you can't edit a modeled sheet that has no records:

New Modeled Sheet without Records

To get started, click Add Row sheetAddRow.png 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.

sheets in cell explorer

Are Zeroes and Blanks Suppressed?

If zeros and blank rows are suppressed, try showing them. Go to Display Options displayOptions.png. 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 sheetAddRow.png 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.

  • Was this article helpful?