When trying to export from Arena the file is not opening in Excel

Posted on 2016-08-02
Last Modified: 2016-08-03

Background to the question is posted above. I was wondering if anyone on here has come up with a better solution than the ones listed by Freya at Technet. I personally called Microsoft's Office support and they did not have a better answer for me than the one provided.

None of the workarounds posted by Freya allowed Excel to open the files. The only thing that did was going to File>Options>Trust Center>Trust Center Settings>Protected View Menu and then uncheck the box "Enable Protected view for files originating from the internet". This has worked on most of the machines that I have come across on our network.

Our network admin doesn't want to implement a global policy change affecting protected view for security reasons, but we have been going around changing the protected view settings to allow files from the internet which has been allowing our employees to continue working.

I just was wondering if you guys have heard of any updates to this or know of any better fixes that are out there.


Question by:Garrett
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3

Accepted Solution

Christopher Jay Wolff earned 500 total points
ID: 41740142
If it were me, I would be trying to script things so that all files that get downloaded into a folder I choose to set up get unblocked, similar to what Freya said for option 2 using a button.  All the docs I read say the unblock button has to do the trick.  But you say it doesn't work in your situation?  It seems it really has to work if you're using NTFS.

Here is a lot of info about Attachment Manager and how it works to block a file, and how you must have NTFS.  You may also like customizing Attachment Manager via the Registry by script if possible, or setting up Attachment Manager via GPO.

And here are the basics of how to use Powershell to unblock files in a folder.  See examples at the bottom.

Author Comment

ID: 41740573
That is an awesome solution, and probably more secure than disabling the protected files view from all folders from the internet, but because we are on a network where not every user is an admin then they cannot unblock the files by right clicking and then clicking unblock. At least I thought you had to have administrative privileges to perform that action.

Expert Comment

by:Christopher Jay Wolff
ID: 41740638
To try it, I just created a new local user account.  Downloaded a file to the desktop.  Properties, security, advanced, shows I have full-control on permissions for that file and that I'm the owner of the file.  The unblock button worked..

I would imagine some specific things are in place where you work to control permissions.  You might check if this type of solution is viable there.  Then if we know what constraints you working under maybe there is another way.  Your admin may have a long to-do list and doesn't want to add to it, huh?

Could you make sure you're the one signed-in, create a newly downloaded blocked file with Save As, right-click the file, properties, security, advanced, and tell us if you're the owner, and if you've got full control assigned?  Then maybe you can see what admin is doing to blocked downloaded files.
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI


Author Comment

ID: 41740765
You are right my friend. I will have to script this out and present it to our network admin as a possible solution that is safer than what we are currently implementing.

Thank you!

Author Closing Comment

ID: 41740766
Good Stuff. Thank you for your help!

Expert Comment

by:Christopher Jay Wolff
ID: 41740821
You're welcome and thank you.  Glad to be of help.

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question