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
Solved

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

Posted on 2016-08-02
6
117 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
Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Cloud-based technologies and services will continue to grow in popularity in 2017 thanks to the simple, scalable and cost-effective solutions they deliver. Here are three areas where cloud adoption is poised to really take off.
Adoption of Microsoft’s Enterprise Mobility and Security solution and Office 365 will re-order the File Sync and Share market Microsoft has stated that its Enterprise Mobility + Security (EMS) is the fastest growing product in the history of the …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

808 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