Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unable to open spreadsheet (2000)

    I have a spreadsheet that is available to a number of people on a shared drive on a network.

    Suddenly, last week, no-one can access the spreadsheet and we get an error message that says:
    Cannot open [file name]. The document may be read only or encrypted.

    There is no encryption on the file, no password, is not marked as read only, nothing.

    I am having trouble finding any references to similar problems with Google so thought I would come here. What references I have found refer to Excel 2007 rather than Excel 2000. There are no Excel 2007 installations.

    I cannot rename the file, cannot move the file, cannot get into the file. If I try any of these things I get the "access is denied" message that refers to the disk being write protected or full. Neither of these cases is true.

    Does anyone have any ideas of how to rescue the data?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unable to open spreadsheet (2000)

    Does the free utility UNLOCKER help?

  3. #3
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to open spreadsheet (2000)

    Hans,

    Thanks. Unlocker was unable to 'unlock' as it 'gound no lock handle', but offered to move, delete or rename it. I tried the rename. That worked. But I am still unable to open the file. I tried to rename it back to the original and Unlocker could not do that until next reboot. Unfortunately, the machine holding the file is the server so there can be no reboot until after hours.

    Attempting to move the file (to my USB stick for instance so I can take the file to a 2007 machine) has also been fruitless.

    But it demonstrates that there really is no lock on the file. Just some sort of corruption.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unable to open spreadsheet (2000)

    That doesn't sound good. I'd wait until the server has been rebooted - perhaps you'll be able to copy / move the file then. If not, the file is probably corrupt beyond recovery.
    In the meantime, do you have a snapshot feature turned on on the fileserver? If so, you should be able to try various previous versions.
    Otherwise, a recent non-corrupt backup is probably your best bet.

  5. #5
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to open spreadsheet (2000)

    Thanks Hans,

    I will try the backup method and report back

    Report Back: Restore from backup was successful. Thanks for your help and suggestions.

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

    Re: Unable to open spreadsheet (2000)

    Just a question: Is this file by any chance in Shared mode?

    If so, your problem proves the point I'm about to make: Do NOT use Excel's shared workbook feature to enable multiple users to access a file at the same time. Excel is not the right application for this. It is at best unreliable and you risk loss of data.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to open spreadsheet (2000)

    Pieterse,

    Thank you for that heads up. Yes I know all about the Shared Workbook from previous experience and feel the same way that you do.

Posting Permissions

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