Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    May 2007
    Posts
    40
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Screen Corruption (2007)

    I have one workbook with VBA code that consistently results in screen corruption.
    This WB has routines that read data every minute from another workbook loaded into the same instance of Excel. My code uses an Excel timer to trigger these tasks. After reading the data from the other wb, some data analysis is done and the results written to both a cumulative array and to a worksheet in the wb with the timer. The routines run every day from 7:30AM to 4:15PM.

    I have been running these routines in Excel 2003 for 2 years with no problems. Now, about 1.5 hrs after starting the workbook every morning, I spontaneously get disabling screen corruption in this workbook only. Control buttons disappear, although their tips will appear if I put the cursor over the spot where the control (such as minimize, close, maximize) should be. The ribbons also become unusable. The interesting thing is that the code is still running as it should in the background although I cannot see the results of what it's doing. If I try to Save the workbook after corruption appears I get an ominous message box saying "Catostrophic Failure." I can get rid of this box but nothing changes. The save I did goes through despite the message.

    I've tried many things to fix the problem. I've made sure that all my drivers are the latest, particularly the video driver. I'm running:
    Win xP SP2 and all updates
    NVidia GeForce 7900 video card, with 256 kb video memory
    Core2 Duo system with 4GB memory
    Plenty of disk space.
    I've tried turning off write-combining for my video card and it made no difference. Nothing makes any difference. The screen corruption always happens with this particular workbook and its routines.

    Any suggestions or thoughts?

    Appreciate any help.

    6rtury

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screen Corruption (2007)

    In another thread in this forum changing the printer driver solved a display problem with Excel 2007.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Lounger
    Join Date
    May 2007
    Posts
    40
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Re: Screen Corruption (2007)

    Ah.. never thought of this one, since during the hours that this workbook is running I never do printing. I have two main printers, none connected directly to this machine. They are connected to the second computer on my home LAN and I do not turn them on during the day. I realize the drivers are installed, however, and nothing surprises me anymore when it comes to problem causes. I have an Epson 2200, an Epson HP-LJ 4M, and 2 virtual printers, such as the PDF printer. Again none of the physical printers is turned on during the day, and the problem occurs even when no printing, real or virtual, is done.

    I haven't updated either the Epson or HP drivers for about 6 mos, so maybe it's time to check. I do do XP updates and I assume that printer driver updates would show there also. Will check directly, however.

    I'm coming to suspect that because Office 2007 has been optimized for Vista, and since Vista handles memory quite differently, I may never solve the problem until I upgrade to Vista -- which won't occur until Vista's SP1 appears.

    Can you give me a link to that other screen corruption email? I haven't pulled it up on a search. Thanks.

    6rtury

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screen Corruption (2007)

    I think Jan Karl was refering to post Excel Charts (2007) <post:=649,802>post 649,802</post:>.
    Legare Coleman

  5. #5
    Lounger
    Join Date
    May 2007
    Posts
    40
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Re: Screen Corruption (2007)

    Thanks Legare. I've read through the entire thread and am trying 2 ideas. First, I've changed the default printer on this computer to one that is conncected physically, the Epson 2200 (even though it's not online during the day). Previously, my default printer on this machine is set to the HP LaserJet 4M, which is physically connected to the networked computer. Second, I've backed of my video acceleration a tad. It doesn't seem to make any visible difference and it may stop the corruption. I'm working in the dark here, but I may stumble on a solution.

    Now, the workbook that is having these problems does have a chart sheet, although I don't even look at the realtime chart until the end of the day. (By the way, this wb is accessing real-time stock market data during the day and using it in calculations.) The chart is bitmapped, and that thread mentioned that Excel 2007 is probably using printer drivers to build bitmaps. I don't know enough about this topic to even comment.

    So far, since the 2 changes I haven't experienced any corruption, but the day is still young. Will let you know.

    6rtury

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •