+ Reply to Thread
Results 1 to 8 of 8

Microsoft bug in Excel 2007

  1. #1
    Registered User
    Join Date
    08-27-2004
    Posts
    13

    Bug in Excel 2007 : Fix available

    Is Microsoft going to fix the bug in Excel 2007 which returns 100000 as the product of 850 and 77.1?
    Last edited by dominicb; 10-11-2007 at 06:39 AM.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning Andrew Turek

    No word from Microsoft (yet) on the issue but my guess is they'll have a fix for it very soon. This will be soooooooooo embarassing for them, even a bigger clanger to drop than Intel did with their faulty chip a couple of years back ...

    DominicB

    Edit : For those not in the know :
    http://groups.google.com/group/micro...8806d5400dfe22
    Last edited by dominicb; 09-26-2007 at 03:57 AM.
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    08-27-2004
    Posts
    13

    Intel

    I had forgotten that incident.

    "How many Intel engineers does it take to change a light bulb?


    1.99999999999 to a sufficiently good approximation!"

  4. #4
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Talking

    Hi Andrew Turek

    "How many Intel engineers does it take to change a light bulb?
    Like that one

    DominicB

  5. #5
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

  6. #6
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Excel 2007 bug : Fix available


  7. #7
    Forum Contributor harrywaldron's Avatar
    Join Date
    05-24-2007
    Location
    Roanoke, VA
    MS-Off Ver
    Office Professional 2010 BETA
    Posts
    169

    Lightbulb

    To complement the blog entries above ... Office 2007 users should patch their systems just in case they may encounter the rare conditions that might trigger this calculation error. Fortunately, the calculation results are correct, but they will be displayed incorrectly in the cell itself. The Hotfix is large at 34MB in size

    Excel 2007 - Hotfix released to correct calculation bug
    http://support.microsoft.com/default.aspx/kb/943075/

    Excel 2007 Services - Server based release for Sharepoint environment
    http://support.microsoft.com/default.aspx/kb/943076/

    This hotfix package fixes the following issue that was not previously documented in a Microsoft Knowledge Base article:

    When you perform a calculation in Excel 2007, the following behavior occurs:

    • The result of the calculation is a number from 65534.99999999995 to 65535. The calculation is performed correctly. However, the result is incorrectly shown as 100000.

    • The result of the calculation is a number from 65535.99999999995 to 65536. The calculation is performed correctly. However, the result is incorrectly shown as 100001

  8. #8
    Registered User
    Join Date
    08-27-2004
    Posts
    13

    Smile

    Good news and it worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1