PC Review


Reply
Thread Tools Rate Thread

Bug with newest Excel Update

 
 
Programming Layperson
Guest
Posts: n/a
 
      17th Nov 2009
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/comm...el.crashesgpfs
 
Reply With Quote
 
 
 
 
John Crosher
Guest
Posts: n/a
 
      26th Nov 2009
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.

"Programming Layperson" wrote:

> 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/comm...el.crashesgpfs

 
Reply With Quote
 
John Crosher
Guest
Posts: n/a
 
      26th Nov 2009
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:

> 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
>
> .
>

 
Reply With Quote
 
Oliver Sturm
Guest
Posts: n/a
 
      8th Dec 2009
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
newest critical update jmommc Windows XP Performance 0 13th Jul 2004 09:14 AM
Re: Newest Update Jose Francisco Windows XP Basics 0 12th Sep 2003 08:48 AM
Newest Update Tallman Windows XP Basics 0 12th Sep 2003 06:45 AM
Re: the newest secruity update Norm Windows XP General 1 18th Jul 2003 12:03 AM
Re: the newest secruity update Nicholas Windows XP General 0 17th Jul 2003 10:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:12 AM.