Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    San Francisco Bay Area, California, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Corrupt Workbook (2000 9.0.4402 SR1)

    I have a corrupt workbook that can't open. Message: xxx.xls file cannot be accessed. Have tried opening through IE, Word, XL Viewer; also OfficeRecover, ExcelFix.

    Other suggestions?

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Corrupt Workbook (2000 9.0.4402 SR1)

    Hi Andy,

    Sometimes you can use a new workbook to import data via external link referencing to a corrupt workbook. The formulae go something like:
    ='C:My Documents[1984.xls]Sheet1'!A1
    which you'd put into A1 and copy across/down as far as needed.

    I've also seen corruptions that cause Excel to return a message saying the workbook is in use/locked. This has been caused where the user exceeds their disk quota on a Novell network. You may end up with a 16kb (or whatever the cluster size is) file that simply can't be recovered because there's nothing worthwhile left from the original. Might be time to resort to the backups.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    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: Corrupt Workbook (2000 9.0.4402 SR1)

    In addition to macropod's suggestion, this MS Article has info on Methods to recover from a corrupt file.

    Steve

  4. #4
    New Lounger
    Join Date
    Jan 2003
    Location
    San Francisco Bay Area, California, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt Workbook (2000 9.0.4402 SR1)

    Thanks. Nothing's worked. The users reverted to an earlier version and repeated the work. FWIW: (1) the workbook was being shared by multiple users and (2) no evidence yet that network drive capacity was a problem.

    Prior corrupt files that I've had have resulted from a network blip -- I've never had a workbook corrupted when it was on a local drive. Anyone else?

    There were some results from OfficeRecovery.com, but the user wasn't willing to spend the $$$ for a full copy.

  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: Corrupt Workbook (2000 9.0.4402 SR1)

    I have never been a "fan" of excel's file sharing. It seems prone to problems.

    In <post#=299620>post 299620</post#> I describe a little of why corruption can occur and why excel may "choke" on shared files. I am sure if you looked, you could find other "real testimonials" on sharing's downfalls

    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
  •