ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tab status (https://www.excelbanter.com/excel-discussion-misc-queries/154974-tab-status.html)

Karene

Tab status
 
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

Tab status
 
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


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com