A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Inconsistant calculations



 
 
Thread Tools Display Modes
  #1  
Old April 1st, 2005, 08:38 PM
Kulwant
external usenet poster
 
Posts: n/a
Default Inconsistant calculations

Hi,

I have a large spreadsheets which has changed to Itterations and
manual calculation. I have just upgraded from Excel 2000 to Excel
2003 and have a relatively large model approx 20MB's.

My problem is that in some cases I will have a cell say CR55 which is
a sum of the numbers above it and displays a value of 10. Then I have
another cell CS54 which is =CR55 however the value comes up as 15 when
it should come up as 10. To further test the situation I went to
another cell on the sheet and made this = C55 and the right value of
10 shows up.

When I go to calculate sheet the error corrects itself. However when
I hit F9 the error occurs again. Basically I'm getting two different
results depending on how I calculate. (F9 or Calculate sheet). The
problem is that the end result that my output is on a different sheet.
The problem is on Sheet 1 and this number is used on sheet 2 and
sheet 2 is used to calculate a number on Sheet 3 which is used to
calculate output on sheet 4. It is not feasible to calculate every
sheet in the workbook all the time.

This problem didn't happen in Excel 2000. However once opened in 2003
and then re-opened in 2000 the problem persists. However if I goto a
backedup version of the model that was never opened in 2003 and open
in 2000 the problem is non-existant and everything is "perfect"!

Thanks
Kulwant
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculations in a query...Is there a max count? HD87glide Running & Setting Up Queries 3 February 15th, 2005 07:29 AM
Date Calculations for Staff [email protected] General Discussion 1 December 10th, 2004 11:11 PM
Calculations vbc22 General Discussion 0 November 17th, 2004 11:38 PM
auto calculations thaddeus Worksheet Functions 2 October 28th, 2003 03:05 AM


All times are GMT +1. The time now is 02:41 PM.


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