LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default Weird screen refresh problem in Excel 2003 - bits of differentworksheets display.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Screen refresh problem Alex St-Pierre Excel Programming 8 December 30th 10 07:25 PM
Weird Excel 2003 macro problem LindaB789 Excel Discussion (Misc queries) 2 July 30th 09 08:40 PM
Display Problem in Excel 2007: Screen flickers an rows blanked out OZL103 Excel Discussion (Misc queries) 2 June 23rd 08 05:23 PM
Screen refresh problem. Nigel Brown[_2_] Excel Programming 0 September 17th 03 03:21 PM
Screen refresh problem. Nigel Brown[_2_] Excel Programming 0 September 17th 03 02:15 PM


All times are GMT +1. The time now is 04:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"