Solved

Excel files protected mode

Posted on 2016-08-03
4
39 Views
Last Modified: 2016-08-08
I have users that run an online application where they can export excel files. When they open the files they are blank. They have to either save the files and go to properties and select unblock or else go to trust settings in excel and de-select enable protected view for files originating from the Internet ( this obviously opens up a potential security issue as other unsafe files from the Internet can also be opened)

Is there an easier way of enabling users to open the file? Thanks
0
Comment
Question by:Sid_F
  • 2
4 Comments
 
LVL 35

Assisted Solution

by:Terry Woods
Terry Woods earned 250 total points
ID: 41741499
It may not be possible in this case, but exporting as a .csv file avoids the issue.
0
 
LVL 9

Accepted Solution

by:
Christopher Jay Wolff earned 250 total points
ID: 41742366
Does this similar recent discussion on EE generate any ideas for your environment?  It sounds like you want to automate unblocking downloaded files

https://www.experts-exchange.com/questions/28961072/When-trying-to-export-from-Arena-the-file-is-not-opening-in-Excel.html
0
 
LVL 5

Author Comment

by:Sid_F
ID: 41747077
thanks
0
 
LVL 9

Expert Comment

by:Christopher Jay Wolff
ID: 41747242
You're welcome.  Thank you.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Outlook Free & Paid Tools
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

762 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

19 Experts available now in Live!

Get 1:1 Help Now