Mode Indicators in Excel?

  • Thread starter Thread starter Spalding
  • Start date Start date
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
 
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
 
Thanks Niek. That status line is pretty easy to miss unless you're use
to looking at it
 
Back
Top