I have following formula in sheet COUNTA(D6:D28), it works beautifully, the whole sheet is protected as it's for my boss and he's prone to bugger things up.
I need to change the range to finish on D27 now, easy peasy, I thought.
I unprotected the sheet, and changed the value.................it wont work.
The formula is displayed in the cell instead of the answer??
The answer is used in another sheet, but I even tried copying the sheet to a new workbook and changing the formula to no avail. I'm sure it must be something stupid, but I am a fafirly competent excel user and have never been unable to change a formula in a sheet???
Help please.
Ps , I cannot change ANY of the formulas in the sheet not just this one
I need to change the range to finish on D27 now, easy peasy, I thought.
I unprotected the sheet, and changed the value.................it wont work.
The formula is displayed in the cell instead of the answer??
The answer is used in another sheet, but I even tried copying the sheet to a new workbook and changing the formula to no avail. I'm sure it must be something stupid, but I am a fafirly competent excel user and have never been unable to change a formula in a sheet???
Help please.
Ps , I cannot change ANY of the formulas in the sheet not just this one