ToolsOptionsCalculation.

Are you set to Manual or Automatic?

If the calcs are taking place when you save, I would suggest the you are in
Manual mode with "recalculate before save" checked.


Gord Dibben Excel MVP

On 28 Jan 2005 08:00:50 -0800, wrote:

Debra,

Thanks so much for the reply. Your code worked great. I have had the
spreadsheet up and running for a week now but for some reason I started
having trouble today. The buttons I use to run DVUp and DVDown still
work as the well name changes but now my data does not change as the
well name changes. Each wells production is listed by day using a
vlookup on the name. Now when the name changes using DVUp or DVDown the
formula does not update itself unless I either 1) hit save or 2) hit F2
on each formula (LOTS of formulae). Any ideas why my formulas stopped
auto updating? I have never seen this before.