My gut tells me to see if calculation is set to manual.
Go to Tools Options Calculation tab and see what box
is checked.
HTH
Jason
Atlanta, GA
-----Original Message-----
The numbers on our production sheet have stopped
calculating. I checked the
formulas and they are correct, but the numbers no longer
add up. If the
numbers in a row are changed, the totals at the end of
the row still remain
the same as they were before a number was changed. This
applies to columns
as well. In addition, if numbers in a column or row are
copied and pasted to
a different excel worksheet, that worksheet will not
calculate those
numbers, even though the worksheet they were pasted to
works fine. You can
see the numbers in the worksheet, but the worksheet
doesn't seem to read
them. Anyone have any ideas what could be wrong and how
to fix it? Thanks in
advance.
Trevor
.
|