Debra Dalgleish explains it and offers some work-arounds:
http://contextures.com/xlautofilter02.html#Count

Karene wrote:

I have a status of Filter mode on one tab of a spreadsheet, this normaly
reads ready, and now calutarions do not compute ? How can I reset this?
There are no filters set on the spread sheet.

--

Dave Peterson