Forum Discussion

Copper Contributor

Dec 14, 2021

Greyed formula that won't delete

I have a formula in a cell: =+K3:K4/K4 The formula is grey and every time I hit delete, it comes back. I can overwrite it but not delete it. However this happened is purely accidental. I cannot fi...

excel

Jon_Steele

Copper Contributor

Jan 20, 2023

Hi, There, Stumped650,

Hopefully not too little too late, but I just recently had this issue and found this thread. I have a simple concatenate formula that borrows values from other sheets in the same workbook.

="Submissions= "&Tracker!Q1&", ORT tasks= "&'ORT Tasks'!Q1:Q2

Now, the cells referenced in both sheets are merged with the cells below them, but for some reason, the reference to ORT Tasks!!Q1 also included merged cell Q2 which created the issue of the greyed out indelible formula just below the cell with my formula.

After tinkering with it , I fixed it by simply erasing the cell callout to "Q2." Not sure exactly what was happening, but once I erased Q2, the problem went away.

Hope this helps.

Cheers,

Jon

SamSam1285

Copper Contributor

Mar 08, 2023

Jon_Steele Its because the Formulae is referencing from merged columns. In my case, the formulae under column D was spilling over to Cell under E and was showing that greyed formulae that i could not delete and i could not get rid of it. After examining the formulae under D, it was Showing 'WPMG001 - WPA - PPM Only'!H9:I9 when I deleted the portion of the formulae of ":I9" it corrected the issue.

Hope this helps