Microsoft has released a 37MB ‘hotfix’ for the Excel 2007 calculation bug
Excel 2007 calc bug fix
Microsoft has released a ‘hotfix’ for the Excel 2007 calculation bug and it’s worth getting despite the large size. The hotfix here .
Just install the patch – there is no restart or registry changes required. Any worksheets set to manual calculation should be forced to recalc to ensure any bogus cell displays are fixed.
The Excel 2007 fix is 34MB – larger than you might expect. That’s because the fix has to replace the entire Excel.exe (17MB itself) plus other key files for Excel Converter, Graph and OfficeArt.
Generally Microsoft ‘hotfixes’ are only for people with the specific problem addressed by the patch but the calc bug can strike anyone and is easy to overlook.
If you have large and complex worksheets then you could definitely consider applying this fix immediately. Individual Excel 2007 should probably install the hotfix for peace of mind.
It’s a harder call for companies to balance the danger of ‘100,000’ showing instead of the right number against the trouble that can ensue from deploying this hotfix.
You might want to wait until Office 2007 Service Pack 1 arrives, whenever that is.
There is a separate download for Excel Services in Sharepoint Server 2007 here.
- Office update status page
- Excel bug: Row Insertion and cell ranges
- More Excel addition strangeness
- What you see isn’t what Excel knows
- Excel’s problem with 65,535 & 65,536