#1   Report Post  
Trevor J. Wilson
 
Posts: n/a
Default Not Calculating?

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


  #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


.

  #3   Report Post  
JulieD
 
Posts: n/a
Default

Hi Trevor

first check that calculation is not set to manual - tools / options /
calculation

second check that your "numbers" haven't suddenly become text - type in an
unused cell somewhere
=ISNUMBER(A1) where A1 is one of the numbers not adding up and see if TRUE
is returned .. if not, select a cell on another worksheet and copy it,
select your numbers and choose, edit / paste special - Add

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Trevor J. Wilson" wrote in message
nk.net...
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



  #4   Report Post  
Trevor J. Wilson
 
Posts: n/a
Default

The sheet was set for manual calculation. Thanks to both of you for helping.

Trevor

"JulieD" wrote in message
...
Hi Trevor

first check that calculation is not set to manual - tools / options /
calculation

second check that your "numbers" haven't suddenly become text - type in an
unused cell somewhere
=ISNUMBER(A1) where A1 is one of the numbers not adding up and see if TRUE
is returned .. if not, select a cell on another worksheet and copy it,
select your numbers and choose, edit / paste special - Add

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Trevor J. Wilson" wrote in message
nk.net...
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 06:49 PM
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! RICHARD Excel Discussion (Misc queries) 0 March 1st 05 02:53 PM
Calculating Percentages with Variables tssjhs Excel Worksheet Functions 1 January 28th 05 02:27 AM
need help w/formula for calculating overtime hours jv749297 Excel Worksheet Functions 1 January 17th 05 08:54 PM
Formulas not calculating??? J Dizzle Fizzle Excel Discussion (Misc queries) 1 December 31st 04 08:47 PM


All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"