kb973593 bug

  • Thread starter Thread starter Lance Phillips
  • Start date Start date
L

Lance Phillips

Does any one know if Microsoft is aware of the kb973593 bug and if
they are fixing it?
 
Does any one know if Microsoft is aware of the kb973593 bug and if
they are fixing it?
Click to expand...

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.
 
This bug has been reported.

I am confident a bug-fix will be out in due time.


Gord Dibben MS Excel MVP
 
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.
Click to expand...

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.
 
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.
Click to expand...


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



- Zitierten Text anzeigen -
Click to expand...

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
 
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
 
If you use userinterfaceonly to protect your sheets, nothing else need to be
done in the VBA code.
 
"Yes; well, at least I can Google and read."

Good for you Joe. Glad you can and google and I read. I will brush
up on those high level skills. When I read that link early in
December those updates were not there so I thought I would ask on this
board....My apologies...
 
Back
Top