Automatic Calculations

  • Thread starter Thread starter mary
  • Start date Start date
M

mary

Hi,
It doesn't happen all the time but sometimes in my Excel
97 when i'm calulating something i have it set to
automatic calculation in the option menu but then
sometimes it reverts back to manual calculations and its
just very annoying, i wonder is it something i press or
what?? How could i get it to stay on automatic calculation
all the time?
 
Hi

The calculation mode is set by the first sheet you open during your Excel
session. If the first one you open is set to Manual, it will set the
calculation to Manual for the rest of the sheets you open in that session.
 
But when i open the first sheet should it automatically
open in automatic mode or manual?? Is there a way that i
can make it so that every time i open a new excel file
that it will open in automatic mode?? Perhaps it does and
all i do is hit something that changes it so that it goes
to manual-is there a "shortcut key" or something that
might do this, or is it only through the options menu?
 
Hi

You must have saved a worksheet in Manual mode (probably by hitting some
shortcut, as you say). I don't think there's an easy way to find which one
it is, though!!
 
Back
Top