Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoFilter (Temporary Solution)
I've seen several questions about this issue of the Autofilter suddenly stop
working. It always seems to be a random event and you can never predict when it will happen, nor can you duplicate it at will. It appears however, if you have formulas within your spreadsheets, every time you filter data, Excel will automatically re-calculate all formulas within your workbooks. So, what I did as a 'test' is to disable the autocalc function (Tools = Options = Calculation) and checked "Manual" and unchecked "Recalculate before save". However, when I'm done with the file, I turn them back on. So far <knock on wood here, I have seemed to avoid the random AutoFilter freezes. Just thought I'd share this info as I'm sure it's as frustrating to others as it is to me when this occurs. Have a great day. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
Autofilter hidding / not usable / disabled -> solution | Excel Discussion (Misc queries) | |||
AutoFilter toggling in VBA (How to use correctly) | Excel Discussion (Misc queries) | |||
Generating excel combinations | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |