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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|
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 |