Formula fields not appearing in the spreadsheet view

Sometimes formula fields do not appear in spreadsheet view.
Even when I click the Show Formula button on a column header and select the formula field to show.
Is there any reason for that?