Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2004
    Location
    San Mateo, California, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    delete a read-only file (XL-XP/2003)

    I need to delete a file that I created for a class that somehow got saved as a read-only file, and now opens everytime I start XL. I have tried to find that file to change its status from read-only to regular, but cannot find it anywhere. Have used Windows Explorer and have used Search, but nothing works. There are NO files showing in the XLStart folder. The file is named "lesson10.XLS" When I select "Save As..." when the spreadsheet is open, it opens XLStart folder and both lesson10.XLS and Personal.XLS (which is a macro file that I'd just as soon delete as well!) show up. But when I try to open XLStart folder via c:ProgramsMicrosoftOfficeOffice10XLStart, NOTHING shows, so I can't select the file in order to change the read-only status, or delete it or whatever. Where do I go from here?

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

    Re: delete a read-only file (XL-XP/2003)

    There are several XLSTART folders. The one used by Excel 2002/2003 is

    Cocuments and Settings<username>Application DataMicrosoftExcelXLSTART

    You can also look if an additional startup folder has been specified in the General tab of Tools | Options... in Excel.

  3. #3
    Star Lounger
    Join Date
    Jul 2004
    Location
    San Mateo, California, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: delete a read-only file (XL-XP/2003)

    Hans -- Many thanks for the information. That solved the problem! Wonder why it's necessary to have multiple XLStart folders? Anyway, I love Woody's Lounge -- the instructor in my online class didn't come up with this answer at all.

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

    Re: delete a read-only file (XL-XP/2003)

    In older versions of Excel, there was only one XLStart folder, under Program FilesMicrosoft Office.... This meant that all users of a PC shared this folder, and used the same Personal.xls. Newer versions use the folder in Documents and Settings<username>..., so that each user can have his/her own Personal.xls and other startup workbooks. They probably left the old folder in place for compatibility reasons. Or perhaps something deep down in Excel gets nervous if it doesn't see an XLStart in the old location...

  5. #5
    Star Lounger
    Join Date
    Jul 2004
    Location
    San Mateo, California, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: delete a read-only file (XL-XP/2003)

    Aha -- that makes sense. Thanks again.

Posting Permissions

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