Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
I have an Excel 2003 system that I wrote for my company about 2 years ago. It collects data from the user on one worksheet and then my macros run and place the data on another worksheet. During my macros the system switches between different worksheets with ScreenUpdating turned off. All of a sudden on some users PCs Excel is not refreshing the screen properly on open (when macros run) and during operation (when other macros) run. What happens is that the screen displays bits of one worksheet and bits of another worksheet interleaved randomly. If you minimise Excel and then maximise Excel again the screen refreshes fine to show just the worksheet it should. You can also make Excel refresh properly by switching to another application (like Windows Explorer) and then switching back - Excel refreshes properly for any part that was covered on the screen by the other application. This problem does not occur on every user's PC - it depends on the version of Excel 2003. So far I have observed it to have the problem on 4 PCs all with build 11.8316 - the PCs that dont have the problem have other builds of Excel 2003. What sort of workaround can I implement? Do I have corruption in the file? Should I pull it apart and rebuild it? Has anyone seem this sort of problem before? Unfortunatley I cannot get IT to install a different build of Excel 2003 onto the users PCs. Thanks in advance for any ideas. Chrisso |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Screen refresh problem | Excel Programming | |||
Weird Excel 2003 macro problem | Excel Discussion (Misc queries) | |||
Display Problem in Excel 2007: Screen flickers an rows blanked out | Excel Discussion (Misc queries) | |||
Screen refresh problem. | Excel Programming | |||
Screen refresh problem. | Excel Programming |