Question Locked

Repeating Cell protection

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a problem with a small block of cells on a spreadsheet. The cells are unlocked in a sheet that is protected and are intended for pasting data copied from an email each day.
The problem is that every time data is pasted the cells protect themselves so that it isn't possible to paste data the following day.
I thought I was going potty when this first started happening and repeatedly reset the format for theses cells to "Unlocked", but every time the result was the same; they locked themselves when data was pasted.
What is going on here and how can I rectify it?

2 replies

This discussion is closed to new replies.