Prev: C# Add-in and PivotTables
Next: putting a picture onto a userform without using the vba window.
From: Josh White on 8 Dec 2009 18:00
I support an Excel 2003/2007 workbook for Siemens Building
Technologies and the workbook performs a lot of background functions
and does a lot of copying and pasting of data from hidden worksheets
to formatted form style sheets. This bug almost renders the entire
program useless. I would be interested to know if there is an ETA for
the fixes that will make the software work again. There is no quick
fix in my case, having 20+ sheets and hundreds of functions and
macros.

On Dec 8, 8:23 am, XL Software Solutions
<xlsoftwaresoluti...(a)googlemail.com> wrote:
> On Dec 3, 4:57 pm, Lance Phillips <lgp.owl.s...(a)gmail.com> wrote:
>
>
>
>
>
> > On Nov 24, 10:46 am, MrXCell <roplopl...(a)gmail.com> wrote:
>
> > > On Nov 23, 5:36 pm, Lance Phillips <lgp.owl.s...(a)gmail.com> wrote:
>
> > > > Does any one know if Microsoft is aware of the kb973593 bug and if
> > > > they are fixing it?
>
> > > Exactly what problem are you referring to? Microsoft is working on a
> > > fix to the worksheet display corruption problem induced by KB973593 on
> > > Excel 2007. KB973475 has done the same to Excel 2003. Have you been
> > > experiencing other problems following the installation of KB973593? If
> > > so, please post details here.
>
> > In some cases userforms will disappear from view. When you click the
> > screen it will reappear. This does not happen if the security update
> > is removed.
>
> I've had to rewrite a lot of code for my product because of this issue
> - some workarounds I found (Excel 2007):
>
> In VBA, program a zoom in / zoom out function. It seems that when you
> zoom on a page it refreshes the worksheet and displays correctly.
> Function ZoomFix()
>      ActiveWindow.Zoom = ActiveWindow.Zoom - 1
>      ActiveWindow.Zoom = ActiveWindow.Zoom + 1
> End Function
> If you have code that interacts with the Application.ActiveWorkbook
> object you will see these issues, so call the zoom function mentioned
> above at the end of your code.
>
> I hope this helps
>
> Regards
>
> Dave

From: Gord Dibben on 8 Dec 2009 19:46
To date no one has received notice of an ETA for the fix.

There will be one...............in the meantime uninstall the two updates.


Gord Dibben MS Excel MVP

On Tue, 8 Dec 2009 15:00:02 -0800 (PST), Josh White <joshbwhite(a)gmail.com>
wrote:

>I support an Excel 2003/2007 workbook for Siemens Building
>Technologies and the workbook performs a lot of background functions
>and does a lot of copying and pasting of data from hidden worksheets
>to formatted form style sheets. This bug almost renders the entire
>program useless. I would be interested to know if there is an ETA for
>the fixes that will make the software work again. There is no quick
>fix in my case, having 20+ sheets and hundreds of functions and
>macros.
>
>On Dec 8, 8:23�am, XL Software Solutions
><xlsoftwaresoluti...(a)googlemail.com> wrote:
>> On Dec 3, 4:57�pm, Lance Phillips <lgp.owl.s...(a)gmail.com> wrote:
>>
>>
>>
>>
>>
>> > On Nov 24, 10:46�am, MrXCell <roplopl...(a)gmail.com> wrote:
>>
>> > > On Nov 23, 5:36�pm, Lance Phillips <lgp.owl.s...(a)gmail.com> wrote:
>>
>> > > > Does any one know if Microsoft is aware of the kb973593 bug and if
>> > > > they are fixing it?
>>
>> > > Exactly what problem are you referring to? Microsoft is working on a
>> > > fix to the worksheet display corruption problem induced by KB973593 on
>> > > Excel 2007. KB973475 has done the same to Excel 2003. Have you been
>> > > experiencing other problems following the installation of KB973593? If
>> > > so, please post details here.
>>
>> > In some cases userforms will disappear from view. When you click the
>> > screen it will reappear. This does not happen if the security update
>> > is removed.
>>
>> I've had to rewrite a lot of code for my product because of this issue
>> - some workarounds I found (Excel 2007):
>>
>> In VBA, program a zoom in / zoom out function. It seems that when you
>> zoom on a page it refreshes the worksheet and displays correctly.
>> Function ZoomFix()
>> � � �ActiveWindow.Zoom = ActiveWindow.Zoom - 1
>> � � �ActiveWindow.Zoom = ActiveWindow.Zoom + 1
>> End Function
>> If you have code that interacts with the Application.ActiveWorkbook
>> object you will see these issues, so call the zoom function mentioned
>> above at the end of your code.
>>
>> I hope this helps
>>
>> Regards
>>
>> Dave

From: xlimits on 10 Dec 2009 02:19
On 9 Dez., 01:46, Gord Dibben <gorddibbATshawDOTca> wrote:
> To date no one has received notice of an ETA for the fix.
>
> There will be one...............in the meantime uninstall the two updates..
>
> Gord Dibben  MS Excel MVP
>
> On Tue, 8 Dec 2009 15:00:02 -0800 (PST), Josh White <joshbwh...(a)gmail.com>
> wrote:
>
>
>
> >I support an Excel 2003/2007 workbook for Siemens Building
> >Technologies and the workbook performs a lot of background functions
> >and does a lot of copying and pasting of data from hidden worksheets
> >to formatted form style sheets. This bug almost renders the entire
> >program useless. I would be interested to know if there is an ETA for
> >the fixes that will make the software work again. There is no quick
> >fix in my case, having 20+ sheets and hundreds of functions and
> >macros.
>
> >On Dec 8, 8:23 am, XL Software Solutions
> ><xlsoftwaresoluti...(a)googlemail.com> wrote:
> >> On Dec 3, 4:57 pm, Lance Phillips <lgp.owl.s...(a)gmail.com> wrote:
>
> >> > On Nov 24, 10:46 am, MrXCell <roplopl...(a)gmail.com> wrote:
>
> >> > > On Nov 23, 5:36 pm, Lance Phillips <lgp.owl.s...(a)gmail.com> wrote:
>
> >> > > > Does any one know if Microsoft is aware of the kb973593 bug and if
> >> > > > they are fixing it?
>
> >> > > Exactly what problem are you referring to? Microsoft is working on a
> >> > > fix to the worksheet display corruption problem induced by KB973593 on
> >> > > Excel 2007. KB973475 has done the same to Excel 2003. Have you been
> >> > > experiencing other problems following the installation of KB973593? If
> >> > > so, please post details here.
>
> >> > In some cases userforms will disappear from view. When you click the
> >> > screen it will reappear. This does not happen if the security update
> >> > is removed.
>
> >> I've had to rewrite a lot of code for my product because of this issue
> >> - some workarounds I found (Excel 2007):
>
> >> In VBA, program a zoom in / zoom out function. It seems that when you
> >> zoom on a page it refreshes the worksheet and displays correctly.
> >> Function ZoomFix()
> >>      ActiveWindow.Zoom = ActiveWindow.Zoom - 1
> >>      ActiveWindow.Zoom = ActiveWindow.Zoom + 1
> >> End Function
> >> If you have code that interacts with the Application.ActiveWorkbook
> >> object you will see these issues, so call the zoom function mentioned
> >> above at the end of your code.
>
> >> I hope this helps
>
> >> Regards
>
> >> Dave- Zitierten Text ausblenden -
>
> - Zitierten Text anzeigen -

Gord, thanks for your information. I hope MS will fix the problem
soon.

btw. Excel 2010 Beta has the same display corruption issue.

Philipp von Wartburg
www.xlam.ch
From: Muhammed Rafeek M on 21 Dec 2009 14:24
Yes, this is a bug and has been reported to Microsoft. Hopefully, MS will fix
these problems asp.

But here is the simple soltuion till MS fix....

Sub Sample_Report_Refresh()
'Set screen update false
Application.ScreenUpdating = False

'Here will come code
'........
'........
'........



'Reset Screen
Application.ScreenUpdating = True
Call Reset_Screen
End Sub
Function Reset_Screen()
With ActiveWindow
.ScrollColumn = 1
.ScrollRow = 1
.Zoom = .Zoom - 1
.Zoom = .Zoom + 1
End With
End Function

Best regards,
Muhammed Rafeek


"Lance Phillips" wrote:

> Does any one know if Microsoft is aware of the kb973593 bug and if
> they are fixing it?
> .
>
From: RobG on 6 Jan 2010 09:38
Has anyone heard of anything from Microsoft on this?
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: C# Add-in and PivotTables
Next: putting a picture onto a userform without using the vba window.