none
issue with opening excel from temporary internet location

    Question

  • Hi

    I have a weird issue with our users on server 2012 which we use as a citrix server.

    when users try to open an excel file from the temporary internet location E::\Users\user\AppData\Local\Microsoft\Windows\Temporary Internet Files\ie\.. or E::\Users\user\AppData\Local\Microsoft\Windows\Temporary Internet Files\content.outlook.

    then excel pops up with file is corrupted, if i copy the file from this location to the desktop/documents etc. then it opens fine, i have tested with new users and its the same issue. i tested with my account and it works fine, fyi dont mention unticking "protected locations" in the excel settings as this is not an option.

    after checking alot of options including the DCOM section, it looks like it could be because the profiles for users are getting created on the E drive not the C drive (where my account is) i have tried to make a test user a local admin on the server and same issue. 

    please let me know if you have any ideas.

    thank you

    Mahesh

    Friday, May 11, 2018 8:57 PM

All replies

  • Hi,

    Thanks for your question.

    Did these files locate in other computers? Could you please drop me a screenshot?

    Please check users profile default location of the PC with the following registry key.

    HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\WINDOWS NT\CurrentVersion\ProfileList

    You may follow this thread,

    How to Change User Profile Default Location in Windows 7

    https://www.nextofwindows.com/how-to-change-user-profile-default-location-in-windows-7

    Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

    Please also check the event viewer for more error message so that we could find more clue.

    Hope this helps. If you have any questions and concerns, please feel free to let me know.

    Have a nice day!

    Best regards,

    Michael

      


    Please remember to mark the replies as an answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Monday, May 14, 2018 7:04 AM
  • Hi

    Michael, the profile is in the correct place (all user profiles are stored in the E drive)

    this is the error in the event log

    Thank you

    Mahesh



    • Edited by mvaghji Tuesday, May 15, 2018 11:43 AM
    Tuesday, May 15, 2018 11:41 AM
  • Hi,

    Thanks for your question.

    Try the following steps as below exhibit to see if it could be of help.

    1. Open Excel.

    2. Click on File > Options.

    3. Select Trust Center > Trust center settings.

    4. Select Protected view.

    5. Uncheck all the options under Protected View > OK.

    6. Restart Excel and try to open Excel documents.

    Best regards,

    Michael


    Please remember to mark the replies as an answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Thursday, May 17, 2018 9:56 AM
  • Hi Michael

    I am unable to tick these settings as its locked down by GPO and we wouldn't want these disabled anyway.

    thank you.

    Mahesh


    • Edited by mvaghji Friday, May 18, 2018 1:19 PM
    Friday, May 18, 2018 1:18 PM