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

To the best of my knowledge, Microsoft is in the final stages of producing
the retail version of the software. If it were me, I would wait for the
retail version and test if. If you find the bug there, there should be
channels for reporting it.

--
Regards,
Tom Ogilvy


" wrote:

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

Tom, thanks for the reply.

My understanding is that the "Gold" code has been released to
manufacturers on Friday. Can anyone with this version of Excel check
to see if the recalculation bug still exists? I would appreciate it
very much as my application relies on circular calculations performing
correctly.

Thanks in advance
Darryl