Results 1 to 10 of 10
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can not open an attachment (Excel 2002/XP)

    A friend of mine sent me an excel file when, when i try to open the file the following error comes up:
    "The File may be read only, or you may be trying to access a read only-location. Or, the server the document is stored on may not be responding".
    I also tried to save the file into C: drive and open it from there, but I get the same error message.

    Thanks,
    Skender..

  2. #2
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can not open an attachment (Excel 2002/XP)

    Does the file open after displaying the message, or does it stay closed?

    Try this:
    <UL><LI>Using the version you've saved to your C drive, right-click on the file within windows explorer.
    <LI>Select Properties
    <LI>Under the General tab, look for the Read Only checkbox, and clear it
    <LI>Press OK and try to open the file again[/list]
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can not open an attachment (Excel 2002/XP)

    i have tried all the options, none of them works...

    Will it make a change if i ask the sender to copy everything he has in his spreadshet into a new spreadsheet.

    cheeers

    skender

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

    Re: Can not open an attachment (Excel 2002/XP)

    That's probably the best option, for the workbook you have now is clearly not usable.

  5. #5
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can not open an attachment (Excel 2002/XP)

    Waiting for sender's reply, i will let you know if that fixes the problem.

    thanks for all your help
    skender

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

    Re: Can not open an attachment (Excel 2002/XP)

    Try to open the workbook using Open and Repair from the File | Open dialog in Excel - see screenshot. Click the Repair option first, and if that doesn't work, the Extract Data option.

    Some other methods are described in Jan Karel Pieterse's article Corrupt Files.

  7. #7
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Piscataway, New Jersey, USA
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can not open an attachment (Excel 2002/XP)

    Hi Hans:

    I don't see a Repair option in File Open and your attached screen shot does not open.

    Please help.

    Thank you,

  8. #8
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can not open an attachment (Excel 2002/XP)

    Are you saving the workbook to your computer, then trying to open it?

    The reason I ask is, at work our email client allows you to open workbooks from within the client.
    Sometimes I get that error when attempting this.

    But if I save it to my computer then I can open it with no problems.

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

    Re: Can not open an attachment (Excel 2002/XP)

    The screenshot in my reply higher up in this thread was lost in the server crash of August 2007.
    I have attached a new screenshot. You have to click the little dropdown arrow on the right hand side of the Open button.
    Attached Images Attached Images
    • File Type: png x.png (12.6 KB, 0 views)

  10. #10
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Piscataway, New Jersey, USA
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can not open an attachment (Excel 2002/XP)

    Thanks, I fixed it.

Posting Permissions

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