Sounds like a corrupt worksheet/file. This has happened to me before.
I seemed to only get around it by copying and pasting into a new
workbook. In particular, I had to copy and paste by highlighting. It
didn't work when I went to Edit/Copy Sheet.