Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2016-08-02
6
Medium Priority
?
181 Views
Last Modified: 2016-08-03
https://social.technet.microsoft.com/Forums/en-US/d2d84793-9920-45e3-baef-5027a4ac1ae0/kb3170008-for-office-2016-breaks-functionality-ms16088?prof=required

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.


Thanks,

Garrett
0
Comment
Question by:Garrett
[X]
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
6 Comments
 
LVL 9

Accepted Solution

by:
Christopher Jay Wolff earned 2000 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.
https://support.microsoft.com/en-us/kb/883260

And here are the basics of how to use Powershell to unblock files in a folder.  See examples at the bottom.
https://technet.microsoft.com/en-us/library/hh849924.aspx?f=255&MSPPError=-2147217396
0
 
LVL 1

Author Comment

by:Garrett
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.
0
 
LVL 9

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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:Garrett
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!
0
 
LVL 1

Author Closing Comment

by:Garrett
ID: 41740766
Good Stuff. Thank you for your help!
0
 
LVL 9

Expert Comment

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

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

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.
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

670 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