Solved

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

Posted on 2016-08-02
6
139 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 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
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

Create Professional Looking Email Signatures

Create "Professional HTML Email Signatures" with ease.
7 Day Money Back Guarantee if not 100% Satisfied.
Affordable - Try it out for 7 Days Totally Risk Free.
Installers provided for over 45 Email clients.
Both Windows & MAC Supported.
Highly Recommended!

Question has a verified solution.

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

Configuring Remote Assistance for use with SCCM
This article is a collection of issues that people face from time to time and possible solutions to those issues. I hope you enjoy reading it.
how to add IIS SMTP to handle application/Scanner relays into office 365.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

751 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