User intermittently can't open emailed Excel files on one specific computer

Chris Dalton 20 Reputation points
2025-12-10T16:58:14.6566667+00:00

Good morning,

I have a rather complicated issue that I'm try to fix without replacing the user's computer. This user receives emails with the same report in Excel a few times a week, but sometimes she gets the error "The operation failed". some details:

  • I, as an admin, can save that file and rename it. When I send the renamed file back to this user she can open it. The original senders (there are two it can come from) can rename it and send it but she gets the same error.
  • Due to protections on the file, she cannot save it or edit it, just view it.
  • The file is unblocked.
  • The recipient, senders, and I's File Block Settings are all the same.
  • The user can sign into Outlook and open that same file no problem on a different computer.
  • Everyone else in that department has reported no issues ever being able to open any of the files sent.

This seems like it's something specifically with that computer, but I'm not sure where I would look.

Thanks in advance for any help!

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

Answer accepted by question author
  1. Ryan-N 8,400 Reputation points Microsoft External Staff Moderator
    2025-12-11T19:07:13.75+00:00

    Hi @Chris Dalton

    Thank you for sharing your updates.

    It is truly wonderful to hear that your issue has been resolved. I sincerely appreciate the effort you put into finding a solution, and I am grateful that you took the time to describe the steps you used. This information will definitely help others who may face the same situation.

    Below is a brief summary of your post to make it easier for other community members to find the key details:

    Issue Description

    • You encountered the error “The operation failed” when opening an Excel file from an email.

    Solution

    • You recreated the Windows profile.

    • You sent the file directly to the recipient instead of sending it through a group.

    Because other users may search for similar issues, your post and the steps you provided will be a valuable reference. If this information is helpful, consider upvoting or marking the answer as the Accepted Answer so others can locate it more easily.

    If you have any concerns or questions in the future, please don’t hesitate to reach out. Not only will I be happy to assist you, but all moderators in the Q&A forum will also do their best to provide support and guidance. 

    Thank you for your kindness and contributions to the forum.  

     

     

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Q&A Assist
    2025-12-10T16:58:29.14+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    It sounds like the issue may be related to the specific configuration or settings on the user's computer. Here are a few troubleshooting steps you can consider:

    1. Check for Updates: Ensure that the Office applications on the problematic computer are fully updated. Sometimes, updates can resolve compatibility issues.
    2. Repair Office Installation: You can try repairing the Office installation on that computer. This can fix any corrupted files that might be causing the issue.
    3. Disable Add-ins: Check if there are any add-ins enabled in Excel that might interfere with opening files. Disabling them temporarily can help identify if they are the cause.
    4. Clear Office Document Cache: Sometimes, clearing the Office Document Cache can resolve issues with opening files. You can find instructions on how to do this in the Microsoft support documentation.
    5. Check File Permissions: Although you mentioned that the file is unblocked, ensure that the user has the necessary permissions to open files from the senders. Sometimes, permissions can be set at the file or folder level that restrict access.
    6. Test with Different User Profile: If possible, create a new user profile on the same computer and see if the issue persists when logged in with that profile. This can help determine if the problem is user-specific or system-wide.
    7. Check Windows Firewall Settings: Since the issue might be related to network settings, ensure that the Windows Firewall is configured correctly and is not blocking any necessary connections.

    If these steps do not resolve the issue, it may be beneficial to gather more details about any error messages or logs that occur when the user tries to open the file. This information can provide further insights into the problem.


    References:


  2. Ryan-N 8,400 Reputation points Microsoft External Staff Moderator
    2025-12-10T18:19:15.6133333+00:00

    Hi @Chris Dalton,

    Welcome to the Microsoft Q&A forum.

    Thank you for reaching out to us. Please allow me to provide you with the following information:

    This issue often occurs because Outlook’s temporary folder (OutlookSecureTempFolder) becomes full or encounters filename conflicts, preventing Outlook from creating a new copy of the file to open it.

     

    Step 1: Clear Outlook cache

    If you are using Outlook Classic, please follow these steps:

    1. Make sure Outlook is completely closed.
    2. Press Windows + R.
    3. Enter: %localappdata%\Microsoft\Outlook User's image
    4. Open the RoamCache folder User's image
    5. Delete all files inside this folder.

    If you are using the New Outlook, please follow these steps:

    1. Press Windows + R.
    2. Enter the command: olk.exe --devtools

    User's image

    1. Select Application.

    User's image

    1. Under Local Storage and Cookie, choose outlook.office.com.
    2. Right‑click and select Clear.

    Step 2: Check Protected View settings in Excel

    1. Open Excel → File → Options → Trust Center → Trust Center Settings → Protected View.

    User's image

    1. Temporarily uncheck all options in Protected View, then click OK.
    2. Try opening the file again from Outlook.

    (After testing, please re‑enable Protected View to ensure security.)

     

    Step 3: Open Outlook in Safe Mode

    1. Completely close Outlook.
    2. Press Windows + R, then enter: outlook.exe /safe
    3. Press Enter.
    4. Try opening the attachment again.

    If it opens successfully, the issue may be caused by an Add-in. Please disable Add-ins one by one under File → Options → Add-ins to identify the problematic one.

     

    Step 4: Check your security software

    • Temporarily disable your antivirus software and try opening the file again.
    • If it works, please add Outlook and Excel to the antivirus software's Trusted List.

    Since the problem only occurs on a specific machine, it is very likely related to that device’s configuration or settings. If the steps above still do not resolve the issue, I recommend creating a support ticket with Microsoft’s technical support team through the Microsoft 365 Admin Center.

    As a moderator-level supporter, I do not have the tools needed to investigate deeper into your system. When you create a ticket, a live agent (technician) will contact you directly and assist with a more detailed check. This will not affect your personal or organizational data — it is simply to ensure no configuration or policy is unintentionally blocking Excel files from opening via Outlook.

     You can refer to the following document: https://dori-uw-1.kuma-moon.com/en-us/microsoft-365/admin/get-help-support?view=o365-worldwide

    I hope the information above is helpful to you. Please try the steps and let me know the results. If the issue persists, I’m ready to assist you further.

    Thank you for your patience and understanding. If you have additional questions, feel free to leave them in the comments under the post so I can continue supporting you.

    I look forward to your response.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.