Solved

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

Posted on 2016-08-02
6
80 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
  • 3
  • 3
6 Comments
 
LVL 9

Accepted Solution

by:
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.
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
Too many email signature updates to deal with?

Do you feel like you are taking up all of your time constantly visiting users’ desks to make changes to email signatures? Wish you could manage all signatures from one central location, easily design them and deploy them quickly to users? Well, there is an easy way!

 
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

Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Join & Write a Comment

Suggested Solutions

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now