EXCEL 2000 problem

  • Thread starter Thread starter John Coombs
  • Start date Start date
J

John Coombs

I am having an intermittent problem with EXCEL 2000.

Normally I can drag a formula across several columns and
it will produce the correct answer for each column.

Currently, when I drag the formula across, although the
formula appears to be correct, the same total appears in
every column, regardless of the content of the column.The
total is the same as the column from where I dragged the
formula.

Also, if I change a column entry, the total will not
update.

This is causing some concern as I have to manully enter
every formula and after I change an entry, I have to
manuall repeat the formula.

I am working in a hot and humid part of southern China so
I am wondering if it is a hardware problem as sometimes it
is OK and sometimes not.

Any help or advice would be very welcome.

John
 
John

Tools>Options>Calculation. Make sur "Automatic Calculation" is checked.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top