PDA

View Full Version : Solved: Excel 2007 Multiplication Bug Da Capo...



Wolfgang
09-27-2007, 02:30 AM
Hi all,

I don't want to get picky about that subject but why does the following work?!

If I open the Immediate window and key in the following statement Excel returns the correct result:

?activecell.Value
65535

Best,
Wolfgang

Bob Phillips
09-27-2007, 02:39 AM
Because the underlying value is correct as explained here http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx

Wolfgang
09-27-2007, 02:42 AM
Good morning Bob,

and thank you very much...

Have a nice day and have an Oktoberfest Bier on me...

Best,
Wolfgang

Bob Phillips
09-27-2007, 02:46 AM
Morning Wolfgang,

I would, but I am on the wagon at the moment, total abstinence ... life is hard.

Wolfgang
09-27-2007, 03:14 AM
...my sympathy...