Something, somewhere has changed with protected spreadsheets. In between 2003 and 2007 they decided to get a whole lot tougher.

I discovered that this week when I went to paste a bunch of answers into a protected spreadsheet - only to be told that I couldn’t: "You cannot use this command on a protected sheet..."

Cue frantic email sent to the owner of the spreadsheet… who fortunately had a workaround.

Instead of choosing paste, just right click, select Paste Special, and choose Values.

Easy when you know how!