Reply to thread

Message: [QUOTE="dasmith, post: 6187964"] I think I found a possible Excel 2007 Recalculation Bug that I think is very serious for people that use circular calculations. I am not sure how to report the bug to Microsoft. I have been able to reproduce on multiple PCs in my office. I have used this technique for years in previous versions of Excel. I am hoping someone from Microsoft will see this and confirm if it is a bug or not. I dont know how to attach a spreadsheet, so here are the steps to reproduce. Step Cell Entry ------------------------------------------------------- 1 Cell (D8) =SUM(D9:D15) 2 D9:D15 enter zeros 3 F9:F15 enter numbers 4 E8 =INT(D8) 5 F15 =IF(E8=0,SUBTOTAL(9,F9:F14), 0) 6 D15 =IF(ISERROR(SUBTOTAL(9,F9:F14)), 1, 0) Do a test - put invalid formula in F12 and error count should go to 1 and total (line 15) should be zero. 7 F12 =9/0 Everything works properly. 8 F12 enter valid number Add a couple of subtotals into the section. 9 Insert blank line after row 10 10 F11 =IF(E8=0, SUBTOTAL(9, F9:F10), 0) Note make sure you enable circular calculations. 11 Insert blank line after row 15 12 F16 =IF(E8=0, SUBTOTAL(9,F12:F15), 0) Now have a total with two subtotals. Change a value to an Error in the top subtotal 13 F10 =9/0 Everything usually calculates properly. 14 F10 Change back to valid number Change value to error in second subtotal. 15 F14 This time the circular calculations will fail. Some or all subtotals will be #Num! 16 Hitting F9 will recalc the error, but on more complex examples the error will not recorrect itself. The version of Excel I am using is: Excel 2007 (Beta) 12.0.4407.1004 MSO 12.0.4407.1005) Beta Any information or confirmation by others would be greatly appreciated. By the Way - I have been having numerous other issues with the beta. Some of these include: - Very frequent crashes. - Calculations completely stopping (F9 or application.calculatefullrebuild) do not fix. The above #Num problem is the only one I can replicate outside of my excel Application so far. Thanks in advance for any help or assistance. Darryl Smith [/QUOTE]

Verification