Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Sep 2003
    Location
    Betekom, Belgium
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    repair workbook no more macros (officexp)

    Hello all,
    I have a nasty problem in excel which sometimes repairs a workbook but in the process deletes all the macro's.
    Can this be avoided ?
    Is one among you who knows the answer or can explain why it cannot be helped?
    Thank You for the support,
    jan

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

    Re: repair workbook no more macros (officexp)

    Yes, Excel sometimes does that. Workbooks that have that happen are mostly corrupt anyway though.
    If you still have an older copy (which already may be corrupt!), try some of the things in this page:

    http://www.jkp-ads.com/CorruptFiles.htm
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Star Lounger
    Join Date
    Sep 2003
    Location
    Betekom, Belgium
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: repair workbook no more macros (officexp)

    Hi,

    I'll try this one thanks. Another question concerning this problem. How does it happen to become corrupt? Anything you can do about it or is it just bad luck?
    Regards.
    jan

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: repair workbook no more macros (officexp)

    Hi Jan

    File corruption in Excel may be down to bad luck though there are some things that can be done to decrease the chance of corruption. Here are some of the things I have seen or used over the years that help, there are probably other things as well.
    <UL><LI>Avoid writing files directly to CD or diskette.
    <LI>Avoid copying a worksheet, then making a copy of that sheet, then a copy of that sheet etc. It is better to make a template sheet and always copy from the original.
    <LI>Drawing objects - Editing drawing objects can cause corruption. It is better to create the drawing objects in a temporary file and when complete copy them into the main file.
    <LI>A mixture of objects such as drawing objects & graphics in a file can make it more susceptible to corruption.
    <LI>Remove superflous rows/columns from a file can reduce the chance of the file becoming corrupt - see <post#=133055>post 133055</post#> for code that can do this.
    <LI>Files that have been in use for a long time are more likely to become corrupt. Copying the sheets into a new workbook can help.
    <LI>Saving a copy of the file in html format and then back into xls format can also clean up a file.[/list]

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: repair workbook no more macros (officexp)

    Additionally:
    Shared workbooks also seem more prone to coruption since excel may be juggling with multiple (major) changes to a workbook when it is saved.

    Steve

Posting Permissions

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