Thank you for the HotFix link. My Excel 2007 had the problem, which is now fixed.
I had hoped that maybe it would resolve a discrepancy between Interactive Brokers Schedule-D and my own Sch-D, but no such luck. I would caution IB customers to be wary of IB's Sch-D download for 2007... their calcs do not appear to be reliable. Set up your own spreadsheet for calculating 'Gain/Loss' from Purchase/Sell prices and if you are like me, your Gain/Loss will not match IB's. In my case, there is a several thousand dollar discrepancy which would reflect against me if I used IB Sch-D data versus actual trading results to report on my tax returns. --- In [email protected], "Tomasz Janeczko" <[EMAIL PROTECTED]> wrote: > > Hello, > > Since some of you are using Excel - > this one is just for Excel 2007 users (pre-2007 versions are not affected), there was a bug in Excel > that caused incorrect results of calculations such as 850*77.1 (should display 65535 but Excel 2007 displayed 100000). > The description and fix on Microsoft pages: > http://support.microsoft.com/kb/943075 > > Best regards, > Tomasz Janeczko > amibroker.com >
