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
|
|||
|
|||
formula recalculation in Excel 2003 - oddity?
have 2 worksheets in a workbook with SUM functions summing up several
cells/rows above them in worksheet 1 SOME of those SUM functions recalculate ONLY when they're edited and entered again OTHERS in the same worksheet, same row, DO recalculate ALL data are numbers I seem to have tried everything (that I know of): 1. change calculation from Manual to Automatic in Tools-Options 2. F9 and SHIFT+F9 3. Calculate method with BeforePrint event (they only recalculated when I used cell.Formula = cell.Formula method) but to no avail (did not tick save and re-open options in Tools-Options deliberately) another worksheet (worksheet 2) in same workbook looks like a mirror copy of the a/m same formulae DO recalculate with no problem has anyone had such a problem? |
#2
|
|||
|
|||
formula recalculation in Excel 2003 - oddity?
Make sure the cells are not formatted as text
Then try Ctr-Alt-Shift-F9 to rebuild the dependency trees and do a full calculate Charles ___________________________________ The Excel Calculation Site http://www.decisionmodels.com "Jarek Kujawa" wrote in message ... have 2 worksheets in a workbook with SUM functions summing up several cells/rows above them in worksheet 1 SOME of those SUM functions recalculate ONLY when they're edited and entered again OTHERS in the same worksheet, same row, DO recalculate ALL data are numbers I seem to have tried everything (that I know of): 1. change calculation from Manual to Automatic in Tools-Options 2. F9 and SHIFT+F9 3. Calculate method with BeforePrint event (they only recalculated when I used cell.Formula = cell.Formula method) but to no avail (did not tick save and re-open options in Tools-Options deliberately) another worksheet (worksheet 2) in same workbook looks like a mirror copy of the a/m same formulae DO recalculate with no problem has anyone had such a problem? |
#3
|
|||
|
|||
formula recalculation in Excel 2003 - oddity?
My tip is that some referred cell's format are different from others behaving
normally. Check it! Regards, Stefi „Jarek Kujawa” ezt *rta: have 2 worksheets in a workbook with SUM functions summing up several cells/rows above them in worksheet 1 SOME of those SUM functions recalculate ONLY when they're edited and entered again OTHERS in the same worksheet, same row, DO recalculate ALL data are numbers I seem to have tried everything (that I know of): 1. change calculation from Manual to Automatic in Tools-Options 2. F9 and SHIFT+F9 3. Calculate method with BeforePrint event (they only recalculated when I used cell.Formula = cell.Formula method) but to no avail (did not tick save and re-open options in Tools-Options deliberately) another worksheet (worksheet 2) in same workbook looks like a mirror copy of the a/m same formulae DO recalculate with no problem has anyone had such a problem? |
#4
|
|||
|
|||
formula recalculation in Excel 2003 - oddity?
cells were formatted as General
thanks a lot Charles, that worked perfect On 18 Cze, 11:13, "Charles Williams" wrote: Make sure the cells are not formatted as text Then try Ctr-Alt-Shift-F9 to rebuild the dependency trees and do a full calculate Charles ___________________________________ The Excel Calculation Sitehttp://www.decisionmodels.com "Jarek Kujawa" wrote in message ... have 2 worksheets in a workbook with SUM functions summing up several cells/rows above them in worksheet 1 SOME of those SUM functions recalculate ONLY when they're edited and entered again OTHERS in the same worksheet, same row, DO recalculate ALL data are numbers I seem to have tried everything (that I know of): 1. change calculation from Manual to Automatic in Tools-Options 2. F9 and SHIFT+F9 3. Calculate method with BeforePrint event (they only recalculated when I used cell.Formula = cell.Formula method) but to no avail (did not tick save and re-open options in Tools-Options deliberately) another worksheet (worksheet 2) in same workbook *looks like a mirror copy of the a/m same formulae DO recalculate with no problem has anyone had such a problem?- Ukryj cytowany tekst - - Poka cytowany tekst - |
Thread Tools | |
Display Modes | |
|
|