Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I get lots of Excel workbooks attached to emails. I make changes to them, but when I go to Save them and send back, I get the "Read-only" file message and have to go through the steps of saving elsewhere with a new name and resending, thus wasting time and space. Is there a setting or something I need to change to stop this annoying situation? I don't recall this in 2003. TYIA!

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,170
    Thanks
    47
    Thanked 980 Times in 910 Posts
    I think it's because Outlook holds the file open when Excel launches.
    To get around it can you send directly from Excel - File > Send To?

    cheers, Paul

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    It sounds as though you have a lot of experience working this way, but for many users, this is a good way to lose the original document and/or lose your changes. Saving to and working from a folder other than the Outlook cache folder is safer. But yes, there are more steps...

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I want to save the file I received with my changes to it. That is what the sender is expecting. Also, that keeps the email chain intact. So I do want to replace the original with my changed copy without having to go the Copy of route.

  5. #5
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,170
    Thanks
    47
    Thanked 980 Times in 910 Posts
    You need to find the copy that has been opened by Outlook and work out why it is read only. It may be an attribute on the file or Outlook may genuinely lock the file. We need to know which.
    To find the file select File | Save As and the dialogue box should show the current path.

    cheers, Paul

  6. #6
    Lounger
    Join Date
    Dec 2009
    Location
    Scotland, UK
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    you should be able to save your changes to your normal work area, Outlook opens temp copy in the Temp Internet Files area of your profile, with a random name such as OLKxxxxx (xxxx=numbers), best to open the attachment, press F12 to Save As, drop it into your My Docs folder make your changes, and then from the Excel File menu you can choose to attach to email and send back without having to leave the app. However, if you wish to use the same email chain that it arrived on, you will have to save the file and then reply to the email and substitute the new file that you edited, from its My Docs location.

    if you don't save the changes to a proper location, when you close the app, Outlook is supposed to delete/remove the temp file created when you opened the attachment from the message.

Posting Permissions

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