You’re using Quick Edit to edit items on a list with multiple pages. While still in the spreadsheet view you go to the next page and find that you’re no longer able to make changes.
The Edit (link to edit item) column! You can’t switch between pages while in the spreadsheet view if you are displaying the Edit column. Remove the column and voila! The cells are no longer grayed out when you switch between pages!