View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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


.