microsoft excel : calculation issue update (fix available)
microsoft excel : calculation issue update (fix available)
welcome to msdn blogs
sign in | join
|
help
the team blog for microsoft excel and excel services.
microsoft excel
this blog
email
syndication
rss 2.0
atom 1.0
search
go
tags
analysis services
backwards compatibility
charting
conditional formatting
excel server
formatting & printing
formulas and functions
how to
integration with word and powerpoint
iteration
other improvements
overview
pdf
pdf, undo, other improvements
pivottables
programmability
rows, columns, performance
smartart
tables
trust center
udfs
undo
archives
november 2007 (2)
october 2007 (4)
september 2007 (4)
august 2007 (7)
may 2007 (1)
april 2007 (2)
march 2007 (1)
february 2007 (2)
december 2006 (2)
october 2006 (3)
september 2006 (18)
august 2006 (15)
july 2006 (12)
june 2006 (14)
may 2006 (15)
april 2006 (11)
march 2006 (12)
february 2006 (11)
january 2006 (6)
december 2005 (11)
november 2005 (17)
october 2005 (17)
september 2005 (4)
faq: how do i register to beta test excel 12?
answer: please register at the office 12 preview site
calculation issue update (fix available)
two weeks ago, we posted about an issue involving the calculation of numbers around 65,535 and 65,536. as of today, fixes for this issue in excel 2007 and excel services 2007 are available for download from the following locations:
excel 2007: http://download.microsoft.com/download/6/1/3/61343075-aa12-4152-a761-fccc16d6cef4/office-kb943075-fullfile-x86-glb.exe 64-bit excel services 2007: http://download.microsoft.com/download/c/d/c/cdcccd84-86cd-4199-b01c-1df2dac66534/office-kb943076-fullfile-x64-glb.exe32-bit excel services 2007: http://download.microsoft.com/download/c/d/c/cdcccd84-86cd-4199-b01c-1df2dac66534/office-kb943076-fullfile-x86-glb.exe
kb articles have been posted as well:
excel 2007: http://support.microsoft.com/default.aspx/kb/943075/ excel services 2007: http://support.microsoft.com/default.aspx/kb/943076
we are in the process of adding this fix to microsoft update so that it will get automatically pushed to users running excel 2007 or excel services 2007. additionally, the fix will also be contained in the first service pack of office 2007 when it is released (the release date for sp1 of office 2007 has not been finalized).
thank you for your patience,
the excel team
published
tuesday, october 09, 2007 5:23 pm
by
david gainer
comments
#
microsoft » calculation issue update (fix available)
tuesday, october 09, 2007 9:04 pm by microsoft » calculation issue update (fix available)
pingback from http://microsoft.whitewitty.info/?p=4926
#
re: calculation issue update (fix available)
tuesday, october 09, 2007 10:10 pm by juan pablo gonzález
thanks for the update david.
#
excel calculation fix
wednesday, october 10, 2007 12:48 am by bart wessels' blog
two fixes came online today for an error in the display of calculation results in excel 2007 and excel...
#
excel 2007で結果が65535, 65536になる計算が100000と表示されるバグ
wednesday, october 10, 2007 2:06 am by 秋元@サイボウズラボ・プログラマー・ブログ
via msdn excel team blog excel 2007を持ってな...
#
re: calculation issue update (fix available)
wednesday, october 10, 2007 4:59 am by mr
we notices that this fix (kb943075) contains two files called excel.msp and oartconv.msp. these file names also appear in fixes kb936509 and kb934391 respectively (the file size is only bit smaller). we just wanted to confirm, if this fix kb943075 replace excel.msp and oartconv.mps files found from fixes kb936509 and kb934391? many thanks.
#
re: calculation issue update (fix available)
wednesday, october 10, 2007 5:31 am by richard black
i tried installing the excel 2007 patch on my desktop pc, but it says:
"the expected version of the product was not found"
the message does not indicate what version it expected to find, or what version it did indeed find.
aggggh.
r.
#
re: calculation issue update (fix available)
wednesday, october 10, 2007 6:26 am by sean
should this fix be run when running office 2002/2003 and using the file format converter?
#
microsoft ya tiene disponible el parche para bug de excel 2007 ( 32 mb)
wednesday, october 10, 2007 6:44 am by noticias-tic.com
hace un par de semanas os coemntabamos un fallo de excel 2007. pues bien, parece que tras un breve testeo micrososft ya ha lanzado el parche que corrige esos errores de cálculo con un tamaño ni mas ni menos que de 32 mb. si te encontrabas afectado po
#
re: calculation issue update (fix available)
wednesday, october 10, 2007 7:12 am by g
just out of interest: any chance of some more information about what went wrong and how? (overoptimized floating-point formatting?)
#
calculation issue excel2007 update (fix available)
wednesday, october 10, 2007 7:17 am by noticias externas
its an important update but size of the update ~33mb. why? what are the things it updated? "two
#
excel 2007 calculation issue hotfix
wednesday, october 10, 2007 9:12 am by guy barrette's blog
#
re: calculation issue update (fix available)
wednesday, october 10, 2007 12:18 pm by dan b (ms)
mr - you can go ahead and install the versions of excel.msp and oartconv.msp from this patch without worrying about losing previous hotfixes. hotfixes are 'rollups' that include all previous fixes.
richard - we've gotten one other report of this and are looking into the possible cause. you may be able to solve it by uninstalling office 2007 and reinstalling it (then apply the patch to a clean installation). if you try that, i'd like to know the results.
seanc - yes, if you are running the excel converter with excel 2002/2003, you should apply this patch, and it will update the converter.
g - the patch is large because it contains updates for several components that use the excel logic that showed this issue - you can see those components listed at the bottom of the kb article. since several of those files are large, it makes the entire patch large.
#
fix the converter?
wednesday, october 10, 2007 1:37 pm by ben m. schorr
just curious, since this is a calculation bug why would we need to fix the file converters? should excel 2003 be doing the calculation and thus be unaffected by a calculation bug that exists in excel 2007? the file converters just allowe excel 2003 to read/write the new xlsx format, right?
or does this bug exist in 2003 as well?
-b-
#
re: calculation issue update (fix available)
wednesday, october 10, 2007 1:59 pm by jack
"or does this bug exist in 2003 as well?"
i'm going to check it out right now.
#
re: fix the converter?
wednesday, october 10, 2007 3:01 pm by bill
i imagine you'd want the fix for 2003 running the converter for 2007 files. if a file comes to you in the 2007 format, and gets converted, it may not fix the error carried by the 2007 version. to my knowledge a similar bug existed in the '95 or '97 version of excel as well, but not the 2003 version.
#
excel services calculation issue update & fix!
wednesday, october 10, 2007 3:21 pm by luisbe on services
please check out david's post for links to the fixes. http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.asp
#
re: calculation issue update (fix available)
wednesday, october 10, 2007 4:39 pm by danglin
it fixed one problem but left the rest 4-4.1 still give 0.0999999996 not .1
#
problem with update?
wednesday, october 10, 2007 7:01 pm by bw
is there is problem with the hotfix(kb943075)? i tried running the update and i'm getting this error:
the installation of this package failed
and
a problem cuased the program to stop working correctly...
thanks.
#
re: calculation issue update (fix available)
wednesday, october 10, 2007 7:16 pm by g
dan b, just for the record it wasn't i who commented on the patch size. (i asked a different question. i fear the answer is no.)
danglin, that isn't anything to do with this issue, it's just the way floating-point arithmetic behaves. (the number you write down as 4.1, as represented in the computer, isn't exactly equal to 41/10.) in principle excel could make 4-4.1 exactly equal to 0.1 by adopting (a) decimal arithmetic instead of binary or (b) exact rational arithmetic instead of floating-point, but there are plenty of other problems with both of those. not least the fact that either would typically be an order of magnitude slower, at least.
#
re: calculation issue update (fix available)
wednesday, october 10, 2007 7:48 pm by dan b (ms)
g - right, sorry about that, i was responding to 'noticias externas.' we're not planning to share details on this beyond what we've already communicated - i.e. that the issue occurred in formatting of floating point numbers near 65,565 and 65,536. it was code that we introduced as part of the calculation overhaul that we did for excel 2007 however.
richard, bw - the one other report we got of the patch not applying correctly turned out to be due to the user having a beta version of office 2007 sp1 installed. the workaround is as i suggested - uninstall office 2007 from add\remove programs, reinstall from the cd, and then apply the hotfix.
#
hotfix failed to install.
wednesday, october 10, 2007 8:52 pm by phawinpon.c
after i tried to install the update, it shown message "the installation of this package failed".
how to correct this problem ?
#
patch per bug nei calcoli di excel 2007
wednesday, october 10, 2007 10:46 pm by il blog di mario
#
microsoft fixes the excel bug
thursday, october 11, 2007 1:47 am by craig bailey link blog
don't dilly-dally, make sure you rush to get the crucial, gaping-hole fixer excel patch for the rounding
#
i bug come evento statistico
thursday, october 11, 2007 3:45 am by marco russo
sarà difficile spiegarlo a chi non è tecnico, ma è un dato di fatto che l'unico programma senza bug
#
corretto il bug di excel 2007
thursday, october 11, 2007 3:51 am by marco russo
pochi giorni fa ho segnalato un bug di excel 2007 , all'interno di un post dove parlavo più in generale
#
re: calculation issue update (fix available)
thursday, october 11, 2007 11:12 am by korn1699
will a new 2003 converter be released with the patch integrated into it?
#
excel 2007 patch for calculation issue released
thursday, october 11, 2007 11:40 am by himanshu
thanks for the update but are you sure that other office apps like ms access are safe enough with such kind of bugs ? there's huge database calculations running in servers.
#
re: calculation issue update (fix available)
thursday, october 11, 2007 5:09 pm by donald f. costello
if microsoft doesnt disclose what they have learned about the cause of the bug then they are dismissing the opportunity to let the emense staff in the foggy computer world help them as they have in probably millions if not hundreds of millions of cases in the past. the sya strategy is not cool.
#
re: calculation issue update (fix available)
thursday, october 11, 2007 10:23 pm by dan b (ms)
himanshu - for this issue, we're sure that other office apps are not affected - we did a very complete test pass.
phawinpon.c (and anyone else who see's the error: "the expected version of the product was not found." all indications are that this means you have a beta version of office 2007 sp1 installed. if you use add/remove programs to uninstall office 2007, and then reinstall office 2007 (but not the sp1 beta), then the patch should apply correctly. this is due to the way office patching works - it only applys to versions of the product that are generally in-market for the public.
korn1699 - we are not releasing a new converter at this time, but this patch can be applied to the converter if you have it installed.
#
re: calculation issue update (fix available)
friday, october 12, 2007 3:37 am by anon
will there be notice given on this blog when this patch hits windows update?
#
excel 2007 display bug fixed
friday, october 12, 2007 6:32 am by another day in the office
unless you have been on a deserted tropical island, you would have heard about the excel 2007 bug whereby
#
re: calculation issue update (fix available)
friday, october 12, 2007 12:36 pm by beelzebubba
duh! that happens to be tha maximim value of integers for a 16-bit os!
ever try to see what the default value for the last cell in excel is? i'll give you two guesses...
i have to chuckle every time i see that one dudes sig that has the faux dictionary entry for windows:
win-does: a 32-bit extention and graphical interface for a 16-bit patch for an 8-bit os from a 2 bit company that can't stand one bit of competion.
...or something along those lines, i'm quoting from memory!
just goes to show how much effort they actually put into futhering their software. just making the "pig" prettier!
cheers,
bryan
#
micorosoft excel 2007 doesn't excel
sunday, october 14, 2007 12:05 am by web white noise
apparently microsoft excel 2007 can't do it's times tables. microsoft employee david gainer, has posted on the excel blog that when computer users try to get excel 2007 to multiply some numbers,...
#
detailed analysis available
sunday, october 14, 2007 8:48 pm by chris lomont
i posted a detailed analysis based on disassembling excel at
http://www.lomont.org/math/papers/2007/excel2007/excel2007bug.pdf
i show why precisely the 12 values format incorrectly, what chnaged from earlier versions, and how the hotfix corrects the bug.
chris lomont
#
re: calculation issue update (fix available)
monday, october 15, 2007 2:24 am by sam
chris,
the most comprehensive and well written article on the subject...i dont think any one in ms could have done a better job...
sam
#
re: calculation issue update (fix available)
monday, october 15, 2007 3:19 pm by bryan villarin
will this be available through windows update?
#
very useful excel feature
tuesday, october 16, 2007 5:10 am by just code - tamir khason
after excel bugs , where resolved , i started to pay attention of what this program provides me. i noticed
#
re: calculation issue update (fix available)
wednesday, october 17, 2007 2:29 am by steven palmer
i tried to apply this patch and it said that "i have no affected products", but i do have office 2007 sbe and my excel 2007 does suffer from the calculation bug.
#
excel bug fixing
wednesday, october 17, 2007 4:53 pm by locuratropical
c'e' stato del trambusto nei giorni scorsi per un bug si excel 2007 dove in visualizzazione anziche'
#
re: the installation of this package failed
saturday, october 20, 2007 3:20 pm by felix
to anyone else getting the "the installation of this package failed" -- it's not a beta version problem necessarily; you also need windows installer 3.1 v2 for the patch files to work. this is available as kb893803.
~felix.
#
re: calculation issue update (fix available)
sunday, october 21, 2007 5:14 am by sam
david,
kindly patch up the copy of excel on your servers... when to "test drive" excel 2007 in the web browser...the rendering bug still appears...
sam
#
re: calculation issue update (fix available)
thursday, october 25, 2007 1:05 pm by longtimeloyaldeveloper,user
>i tried installing the excel 2007 patch on my desktop pc, but it says:
>"the expected version of the product was not found"
>the message does not indicate what version it expected to find, or what version it did indeed find.
dan and dave, and bill and every m.s. developer for that matter: please please study this carefully. that little post may well be the essential expression of what is wrong with microsoft. if you do nothing more before judgment day, "get" what is wrong here. please "get" its inexcusability.
brace yourselves: no, the solution is not to instead say "runtime error 1004, application defined or object defined error"
#
another discrepancy (bug)
friday, october 26, 2007 11:17 am by kanwaljit singh dhunna
hi david,
below is a link highlighting something which i feel should be categorized as a "bug". i am reporting here because i don't where i should have been reporting. sorry for that.
http://www.asap-utilities.com/blog/
problem with copying filtered data in excel 2007 + workaround
it says "you cannot copy only the filtered data in excel 2007. if you use the autofilter to make a selection and then you only want to copy the filtered rows, excel 2007 copied everything, even the hidden rows. this is different from the way excel 2000-2003 works". in that way excel 2000-2003 is better than excel 2007.
regards
ca kanwaljit singh dhunna
india
#
another calculation issue - excel will calculate exactly zero
wednesday, october 31, 2007 3:00 pm by charles
see below
$145,510.22000000000000000000000000000000 +
$(72,140.74000000000000000000000000000000)+
$(32,041.10000000000000000000000000000000)+
$(30,658.61000000000000000000000000000000)+
$(8,848.40000000000000000000000000000000)+
$(800.22000000000000000000000000000000)+
$(521.48000000000000000000000000000000)+
$(499.67000000000000000000000000000000)=
$(0.00000000000289901436190121000000) should be exactly zero where do the extra numbers come from. excel does this on a host of other calculations as well.
new comments to this post are disabled
Acceuil
suivante
microsoft excel : calculation issue update (fix available) Livre The PC Doctor's Fix-it-yourself Guide - A. Kingsley-Hughes ... Fix Our Ferals gratuit : bug in Excel 2007 Calculation Fix available. : tout le ... fix buffalo today [ Esport Magazine - EsportsFrance - Rotterdam est srieux, FiX non ] The Sunshine Fix Data Recovery Disk Recovery Hard Drive Recovery software by ... Le Blog de la Mobilit Data: Zoom sur SFR One Fix Connected ... Paul Fix Disque Pharma-Fix en Silicone/PTFE de 20mm Django Weblog Security fix released Mozilla Firefox 2.0.0.5 Released with Fix for firefoxurl ... Dial-a-fix - TechWiki The Gossip Fix Modernfix.com Motorpsycho - You Gotta Hang On To The Trip You're On... PNG in Windows IE Pants'Fix trousers solution men homme - Vidos Actualits Mode ... Geek to Live: How to fix Mom and Dad's computer REGO-FIX, Swiss Precision Tools - collets, toolholders, nuts ... Top case Topcase bleu claire fix. adossoir moto scoot en vente sur ... Snowboard Nitro Spectrum 157 + Fix snow Nitro en vente sur eBay.fr ... IBM Support: Fix Central Perma-Fix frontline: the alternative fix PBS FixMyStreet Tom Feiza, Mr. Fix-It Inc. Recette du cocktail Brandy Fix :: Les Cocktails Delirium Recette du cocktail Whisky Fix :: Les Cocktails Delirium Suggest A Fix PC Support Forums (Powered by Invision Power Board) Josh Fix Pack Ski+Fix avec le guide du matriel ski/snow d'annuaire-ski.com The Fix - Yeah:No Recordings Get The Curse > pivx_ - home & office NANIA RHAUSSEUR DREAMWAY SP FIX SILVER acheter comparer prix ... BigFix :: Home Lauren Fix: The Car Coach ~ Automotive Expert ThinkGeek :: No, I will not fix your computer Security Fix Live - washingtonpost.com Digg - How Nintendo Can Fix Wii's Storage Space Problem without a ... BBC - Languages - Spanish Quick Fix NPR : Oprah Pledges to Fix School amid Abuse Reports Geotag your blog, site or feed Address Fix WordPress 2.0.6: Feedburner issue, and fix Mark on WordPress High-fi fix for malfunctioning Guitar Hero III Les Paul - Engadget FIX, starring Shawn Andrews, Olivia Wilde, Megalyn Echikunwoke ... WinSock XP Fix 1.2 Freeware download page - tested and reviewed ... Tricky fix-up plan devised for space station- msnbc.com fix M i c h a e l F i x WinXpFix.com Home page (wixpfix.com) Windows xp news, Tips, Free ... Coldplay Fix You Music at Last.fm Amazon.com: War Fix: Books: Steve Olexa,David Axe FIX-TIPS Free Football picks & Best Soccer betting tips, soccer ... Screenplay Coverage from ***** script-fix ***** Editor's Daily Blog: A Temporary Fix fixoyun fix oyun fiks oyunlar fıxoyun fıx oyun fiks oyun fix ... Fix 4 RSO The Fix - Salon.com It's not always malware: How to fix the top 10 Internet Explorer ...