Pasting Formulae

[Martin Smith]

I created a spreadsheet with a formula in A1 repeated
throughout A2 to A499. Cell A1 was CONCATENATE etc which
was fine and the whole sheet was protected.
When I unprotected the sheet and amended the formula, only
the new value was shown but the formula had disappeared.
All other cells were fine except A1!
The recalculated value has replaced the original formula.

Anyone any ideas?

 

[Gord Dibben]

Martin

Show us the formula for A1 and give the steps you used to "amend" it.

Sounds like you just "overwrote" it rather than amended it.

Gord Dibben Excel MVP