Bug with newest Excel Update

Layperson@discussions.microsoft.com Programming Layperson

unread,

Nov 17, 2009, 3:26:01 PM11/17/09

to

The most recent security update (11/11/09) for excel 2003 permanently engaged
the "sized with window" toggle in Excel Charts, making it impossible to zoom
the chart. The full sized charts are inconvenient for copy and pasting
because the formatting shifts unexpectedly.

Other people that I work with are reporting bugs with macros and formulas.
We all use Excel daily for data processing (scientific usage). We have
alternative spreadsheet software available (Igor and Origin), but like the
Excel interface.

Uninstalling this update remedies these errors. Is there a better fix than
uninstalling the update?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=990bd4bd-5153-4649-b12a-f40af110e5f6&dg=microsoft.public.excel.crashesgpfs

John Crosher away with this ATsign

unread,

Nov 26, 2009, 6:42:12 AM11/26/09

to

John Crosher away with this ATsign

unread,

Nov 26, 2009, 6:42:50 AM11/26/09

to

I have also experienced a serious Excel 2003 failure after KB973475 update.

I have developed several programs which uses XL VBA extensively, each in a
workboook with multiple sheets, many formulas and pivot tables. They have
been running successfully in the field for several years. After the recent
KB973475 update they all now fail with many of their displays to the end user
becoming corrupted. The display appears as a mixture of 2 or more sheets, one
of which usually contains a pivot table. This could be damage to the pivot
table, or merely failure of Excel to redraw the screen properly.

The corruption occurs after a pivot table is displayed and then VBA changes
a cell value on a different sheet in the same workbook, causing a
recalculation.
If KB973475 is uninstalled the fault goes away - the Excel file and the VBA
code does not get corrupted by this installation.

Has anyone else experienced this problem?

I definitely need an answer from Microsoft.

Jan Karel Pieterse

unread,

Nov 26, 2009, 6:52:59 AM11/26/09

to

Hi John,

> I have developed several programs which uses XL VBA extensively, each in a
> workboook with multiple sheets, many formulas and pivot tables. They have
> been running successfully in the field for several years. After the recent
> KB973475 update they all now fail with many of their displays to the end user
> becoming corrupted. The display appears as a mixture of 2 or more sheets, one
> of which usually contains a pivot table. This could be damage to the pivot
> table, or merely failure of Excel to redraw the screen properly.
>
> The corruption occurs after a pivot table is displayed and then VBA changes
> a cell value on a different sheet in the same workbook, causing a
> recalculation.
> If KB973475 is uninstalled the fault goes away - the Excel file and the VBA
> code does not get corrupted by this installation.
>
> Has anyone else experienced this problem?

Yes, I have the same issue and so does a customer of mine. The fix is the same:
uninstall KB973475.

I have already opened a bug report with Microsoft about this and requested my
customer to do the same. If you have any support contract with MSFT, please
report this bug to them, it may help getting it fixed.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

John Crosher away with this ATsign

unread,

Nov 26, 2009, 10:49:01 AM11/26/09

to

Jan,

I have already issued a bug report - so far have just received a brush-off
from the agent handling it for Microsoft, saying they don't have the
expertise! They seem reluctant to pass it on to Microsoft support.

"Jan Karel Pieterse" wrote:

> .
>

Jan Karel Pieterse

unread,

Nov 27, 2009, 4:53:24 AM11/27/09

to

Hi John,

> They seem reluctant to pass it on to Microsoft support.

Well, luckily I did already. Hope they'll listen to me...

Sturm@discussions.microsoft.com Oliver Sturm

unread,

Dec 8, 2009, 11:27:02 AM12/8/09

to

We did have the same issues at about 200 PCs who got this Patch from our WSUS.

After we declined the Patch on WSUS the PCs still did have the patch.

However we have been able (fortunatelly even if Excel was running) to
remotely remove the Patch with the following command:

msiexec /package {90110409-6000-11D3-8CFE-0150048383C9} /uninstall
{E76CD647-C9A5-45BC-8B73-D0A7B61050A7} /quiet /norestart

Regards, Oliver

Jan Karel Pieterse

unread,

Dec 8, 2009, 12:45:47 PM12/8/09

to

Hi Oliver,

> However we have been able (fortunatelly even if Excel was running) to
> remotely remove the Patch with the following command:
>
> msiexec /package {90110409-6000-11D3-8CFE-0150048383C9} /uninstall
> {E76CD647-C9A5-45BC-8B73-D0A7B61050A7} /quiet /norestart

Thanks, very useful information!
Did you take the trouble of phoning Microsoft about the issue?
Please do so, so the chances increase they fix this!

You can Call 1-866-pcSafety for free, to report issues with security updates.

Jan Karel Pieterse

unread,

Jan 14, 2010, 9:28:03 AM1/14/10

to

Hi John,

There seem to be two hotfixes to this problem:

KB973475 Excel 2003 hotfix package :

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=978908&kbln=en-us

KB973593 Excel 2007 hotfix package :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;978522Regards,