Mode Indicators in Excel?

S

Spalding

A good example of a missing mode indicator one for whether th
calculation mode is set to manual or automatic. Isn't there any othe
way to find out other than going to the Tools>Options>Calculatio
dialog? This has messed me up almost any time calculation gets set t
manual.

Another example is that trying to use stored Custom Views for filtere
lists gives the error "Some view settings could not be applied" on som
worksheets (usually complex ones), but works OK in others (usuall
simpler ones). I know sheet protection is one thing that can caus
this (which itself has no mode indicator I've ever seen other tha
Tools>Protection), but there must be some other property or settin
that is causing that problem.

Shouldn't the status bar show such indications, like it does for NU
LOCK and CAPS LOCK
 
N

Niek Otten

If Calculation is set to Manual and there is a need for recalculation, the
word "Calculate" shows in the status bar.
This also shows always if there are more than 65K dependent cells. Not very
common.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
S

Spalding

Thanks Niek. That status line is pretty easy to miss unless you're use
to looking at it
 
Top