Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Excel Workbooks being corrupted (Excel 97)

    My colleague at work has been having trouble with large Excel files (8Megs +) being corrupted. <img src=/S/mad.gif border=0 alt=mad width=15 height=15> <img src=/S/hosed.gif border=0 alt=hosed width=73 height=24> These files were someone else's creation, she has been updating them. They are a mixture of worksheets, graphics and pivot tables. She does keep backups, but recently has lost a few days of work after closing the file one day and going home, coming back the next and as soon as she tries to work with the file she gets a Dr. Watson error and it is not a memory protection error. It is one of those obscure errors " .exe has generated bla bla bla". When Dr. Watson finishes, the application closes. This has happened with different files on 2 or 3 occasions. Any thoughts or insight that anyone might provide is greatly appreciated. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Ron M

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

    Re: Excel Workbooks being corrupted (Excel 97)

    The workbook may contain some corruption that is only triggering the problem occasionally, or when she access some particular part of the sheet. If the workbook contains macros, it could also be a macro bug.

    If the workbook contains some kind of corruption, there are a couple of things that you can do. If you can get access to Excel 2000, open the workbook with Excel 2000 and save it. This will sometimes clean up some corruption. About the only other thing that you can do is to copy and paste everything from the workbook into a new workbook.
    Legare Coleman

  3. #3
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Excel Workbooks being corrupted - Thanks.

    Thanks folks. I will pass along your suggestions. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Ron M

  4. #4
    New Lounger
    Join Date
    Jun 2001
    Location
    Oklahoma
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Workbooks being corrupted (Excel 97)

    The problem could be the workbooks were created with another spreadsheet or Excel 5.0 and edited and saved various times with different versions of Excel the last being 97.

    If this begins happening more frequently then you will have to create a new workbook and like the previous poster stated you may have to copy everything to the new workbook. However if you do copy the VBA code into a blank workbook first then back into the VBA editor of the new workbook. Also some conditional formatting and data validation may times need to be recreated, not merely copied. This is a pain, but it is sometime necessary to correct the problem.

    Now has the user added any new sheets? If so how were they added? If the user simply made a copy of an existing sheet it can cause problems in Excel after a certain number of sheets are copied. If you copy a sheet name several times Excel can give the internal sheet names of something like:

    Sheet1, Sheet11, Sheet111, Sheet1111, Sheet11111, etc. After a while you reach Excels naming limit, and it causes the workbook to appear to be corrupted. To see if you have this type of problem waiting in the wings start the VBA editor by pressing ALT+F11 Go to the

  5. #5
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Excel Workbooks - Thanks...

    John, thanks for the lead on the MS recovery tool. I will let my colleague know. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Ken, thanks for the insight on the sheet numbering. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    What you don't know can corrupt you. <img src=/S/blush.gif border=0 alt=blush width=15 height=15> <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> <img src=/S/devil.gif border=0 alt=devil width=15 height=15> <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>

    Ron M

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Workbooks being corrupted (Excel 97)

    Ron,

    Have you tried recovering the corrupted file using MSoft's recovery tool. I have used it with success. You can find the tool at <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q142/1/17.ASP>http://support.microsoft.com/support/kb/ar...s/Q142/1/17.ASP</A>
    <small>Edited to add URL - WebGenii</small>
    John

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

    Re: Excel Workbooks being corrupted (Excel 97)

    Too late this time, but to prevent loss of hours of work in future, start using my Autosafe utility:

    http://www.bmsltd.ie/mvp (Bottom of page)

    You can try opening those files with calculation set to manual and with macro's disabled.
    Sometimes it even helps to switch sheets immediately after the file is opened. Do this by pressing control-pageup(or down) while the file gets opened.

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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