Microsoft Patches Excel 2007 Bug

By Nick Mokey Published October 10, 2007

Microsoft Patches Excel 2007 Bug

If your last Excel spreadsheet calculation was off by say, 34,465 or so, an embarrassed Microsoft can tell you why. The program’s developers discovered two weeks ago that a flaw in the software was turning calculations resulting in 65,535 or 65,536 into 100,000. After coding and testing a fix, the team released a patch on Tuesday.

Apparently, the cause of the glitch was a floating point error causing six numbers between 65534.99999999995 and 65535 to display as 100,000. Entering the number directly into a cell wouldn’t actually cause the glitch, since Excel rounds off all entries to 15 digits, but calculations resulting in those numbers would do it. (Geeky readers wanting to try it out for themselves can use “=20.4*3212.5” in a cell.)

Recommended Videos

Beefy 32MB patches for Excel 2007 plus the 64- and 32-bit versions of Excel 2007 are available from the Excel developer’s blog.

Topics

Editor in Chief

As Digital Trends’ Editor in Chief, Nick Mokey oversees an editorial team covering every gadget under the sun, along with…

Computing

Microsoft is forced to halt the Windows 11 24H2 update on some PCs

The Surface Pro 11 on a white table in front of a window.

Microsoft’s recent Windows 11 24H2 update is off to a bumpy start. According to a report by Bleeping Computer, users are facing compatibility issues across various hardware and software configurations, prompting the company to temporarily block the update for some devices.

The affected systems include specific Asus laptop models and configurations involving software like Voicemeeter, Safe Exam Browser, and older versions of Easy Anti-Cheat, commonly used in gaming.

Computing

I have really good news about Microsoft Teams

Microsoft is bringing some changes to its Teams app in the near-ish future, according to The Verge, including a combined chats and channels view that will go into public preview in November. There are also plans to bring threaded conversations to the app sometime in 2025.

Right now, the Teams app organizes your chats (both one-on-one and group chats) under one tab and your channels under another. Whenever you’re on the chats tab, your channels are just one tap or click away — and yet that one click has a pretty significant impact.

Computing

Snag this excellent 2K gaming PC for just $1,899

ibuypower RDY Y60 005 gaming desktop

If you're not that inclined to build a PC from scratch, then buying a pre-built gaming PC makes a lot of sense, especially since there are a lot of great deals now that more than make up for anything you would lose for not building it yourself. One great example is the RDY Y60 from iBuyPower, a solid gaming desktop from a boutique maker specializing in interesting builds, and the best part is that it has quite a significant discount on it for a configuration that comes with an RTX 40-series card. Instead of the usual $2,349 the RDY Y60 goes for, you can snag it for just $1,899, which accounts for a solid $450 discount. Also, if you use the code IBP25YR, you can get an extra $50 discount, or up to $300 if you spend up to $3,999 on an iBuyPower PC.

Why you should buy the RDY Y60 gaming desktop
One of the most important parts of any gaming desktop is the GPU, and in this case, you get the excellent RTX 4070 Super, which straddles the line between performance and price. This is actually the perfect 1440p GPU since you're going to be getting between 60-100 fps with ultra settings, depending on the game. You could theoretically push it to 4K if you want to pair it with the latest and best gaming monitors, but you likely won't see more than 55-60fps, at best, and you may need to have to play around with graphical settings.