Why an Excel Formula Appears Gray in a Linked Cell in WPS Office Spreadsheets
Question details
The user needs to understand why a linked Excel formula appears gray and cannot be edited directly, and how to modify the source formula when the cell is part of a spilled dynamic array result.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with a linked formula in a spreadsheet and discovers the formula cell is gray and read-only.
- Observed behavior
- The formula appears gray and cannot be edited in the active cell because it is a non-editable result of a dynamic array spill.
Before editing, locate the spill range and identify its top-left cell. Dynamic array formulas can fill neighboring cells automatically, and only the top-left cell stores the editable source formula.
Edit the Spill Formula from the Top-Left Cell of the Spill Range
Use this method when you want to keep the dynamic array formula and only need to change the source formula that creates the gray linked cells.
In a spilled dynamic-array result, only the top-left cell contains the actual editable formula. The remaining cells in the spill range are automatically populated and appear gray because they are calculated results, not independent formulas.
Click the first cell in the highlighted spill area. In WPS Spreadsheets, this is the cell that contains the editable formula, while other cells show gray spill results.
Click the formula bar above the sheet, change the linked formula as needed, and press Enter.
Check the gray linked cells to confirm they refresh automatically with the corrected formula result.
Replace the Spill Formula with Individual References or Values
Use this method when you do not want a spilled dynamic-array formula and need fixed linked cells that you can edit independently.
Edit Gray Linked Excel Formulas in WPS Office Spreadsheets
Open your Excel workbook in WPS Office Spreadsheets, locate the spilled dynamic array formula, and edit it from the top-left cell so the gray linked cells refresh correctly.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office and open the spreadsheet that contains the gray linked formula.
- 2. Locate the spill range: Click the active cell with the gray formula; WPS highlights the spill range boundary and the top-left editable cell.
- 3. Select the top-left cell: Click the top-left cell of the spill range where the actual editable formula is stored.
- 4. Edit the formula: Click the formula bar, change the formula, and press Enter to refresh the linked spill results.
- 5. Save the workbook: Press Ctrl+S or click the Save icon to keep your changes.
Frequently Asked Questions
Why does my formula turn gray when I click a linked cell?
The cell is likely one of the non-top-left cells in a spilled dynamic array result. WPS Spreadsheets displays these dependent spill cells as gray and read-only because only the top-left cell stores the editable formula.
How do I make a gray spilled formula editable again?
Select the top-left cell of the spill range, then click the formula bar. You can edit the formula there and press Enter. You cannot edit the formula directly from the gray spill cells.
Can I remove the spill behavior and keep only the values?
Yes. Select the entire spill range, press Delete to clear the dynamic array formula, and then use Paste Values or enter individual formulas if you want fixed linked values.
Does WPS Office support Excel dynamic array spill formulas?
WPS Office Spreadsheets supports opening and working with common Excel spill behaviors. Open the .xlsx workbook in WPS and use the formula bar from the top-left cell to manage the formula.
