Jessica,

I'm afraid that Frank is not around anymore - he sadly died in a accident on
5 January 2005.

The automatic/Manual setting is taken up from the first workbook opened.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"germanyjessica" wrote in message
...
Frank - Even our IT tech couldn't help me with this problem. Thanks so
much!

If anyone is still out there - can you tell me why it changed and how
never,
ever to let it do so again?


Jessica

"Frank Kabel" wrote:

Hi
goto 'Tools - Options - Calculate' and check 'Automatic calculation'

--
Regards
Frank Kabel
Frankfurt, Germany

"roeaster" schrieb im Newsbeitrag
...
I am using SUMIF and have been able to drag the formula down the column
and the right values pop up. Now, when I drag, the column is filled
with the value in the first cell in the column. After dragging, I can
double click the cells or hit F2 (to edit) then hit enter and the
correct value will pop up.

Once I was able to fix the problem by just restarting my computer but
not anymore. I noticed this is happening with other (maybe all)
formulas so every time I update, I have to go to every cell with a
formula and hit F2 then Enter to make sure the right value is in every
cell - very annoying.

I wondered if this might be some quirky thing that happens after I run
my macro (it turns columns of numbers into text format). Or maybe it's
some weird setting that I accidentally set - one that says "don't
update a cell with a formula until the person clicks on it to indicate
that they want the correct value in this cell."

I don't know, I'm all out of ideas!