| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 display refresh problem
On Dec 30 2010, 6:55*pm, Jojo Rouptchini wrote:
Try hotfix (KB978908). It worked like a charm for me despite the Microsoft disclaimer: "This hotfix has not undergone full testing. Therefore, it is intended only for systems or computers that are experiencing the exact problem that is described in the one or more Microsoft Knowledge Base articles that are listed in "KB Article Numbers" field in the table at the end of this e-mail message. If you are not sure whether any special compatibility or installation issues are associated with this hotfix, we encourage you to wait for the next service pack release. The service pack will include a fully tested version of this fix. We understand that it can be difficult to determine whether any compatibility or installation issues are associated with a hotfix. If you want confirmation that this hotfix addresses your specific problem, or if you want to confirm whether any special compatibility or installation issues are associated with this hotfix, support professionals in Customer Support Services can help you with that." You will have to request the hotfix from Microsoft. They will send you a link to the file as well as a password with which to open it. From there on it is self explanatory. On Friday, July 16, 2010 12:36 AM Chrisso wrote: 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 On Friday, July 16, 2010 12:44 PM Harald Staff wrote: Hi Chrisso Memory and system resources are allocated in mysterious ways. It gets even worse when working with MediaPlayers and those things. The solution is to rewrite your code so that you do not change sheets or selections or anything. Excel can run silent in 99.5% of her operations, and if so noticeably faster than when jumping around. Like, this code Sheets(3).Range("H14").Value = Sheets(2).Range("C14").Value will run with Sheet1 active and you will not see a single flash except perhaps a very very short hourglass. HTH. Best wishes Harald On Monday, July 19, 2010 8:23 AM Martin Brown wrote: On 16/07/2010 17:44, Harald Staff wrote: This rings a bell. There was a graphic driver related update that messes up certain types of Excel screen refresh. Try searching MSKB for details and workarounds (which I think consist of uninstalling a patch). I cannot figure out the right keywords to persuade Bling to show the answer in MSKB but I am pretty sure it is in there isomewhere. And ISTR there was a thread about at the time in microsoft.public.excel.* Regards, Martin Brown On Thursday, July 29, 2010 3:40 AM Chrisso wrote: On 19 July, 13:23, Martin Brown wrote: Thanks for your posts - I will look into both. Cheers Chrisso On Thursday, August 05, 2010 3:00 AM Chrisso wrote: Martin - thanks for the tip. Did a search on my version of Excel and screen refresh and this turned up this thread: http://groups.google.co.uk/group/mic....programming/b... I quote some of this thread here (thanks to Peter T): Microsoft released a Hotfix for the buggy KB973475 patch for Excel2003 download http://support.microsoft.com/hotfix/...=978908&kbln=e... and another Hotfix for the similarly buggy KB973593 for Excel-2007 description http://support.microsoft.com/default...b;EN-US;978522 download http://support.microsoft.com/hotfix/...=978522&kbln=e... Regards, Peter T This looks like my problem exactly: Will update soon. Chrisso Submitted via EggHeadCafe Microsoft SQL Server DBA For Beginners http://www.eggheadcafe.com/training-...BA/6/SQL-S...- Hide quoted text - - Show quoted text - Thanks very much Jojo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
