Solved

Excel 2010 hangs opening Protected Files

Posted on 2011-09-21
7
2,269 Views
Last Modified: 2012-05-12
I have a client who is having problems opening excel documents that are in his Outlook 2010 (With Exchange 2010). Also if he saves them and opens them from the file system he gets the problem as well. It just started happening and he has no idea what has changed.

I found an article that described how to turn off protection, but the options aren't there which I presume is because he runs exchange?

He is accessing this account from within a terminal services session on a 2008 r2 server.
0
Comment
Question by:networkn
7 Comments
 
LVL 2

Expert Comment

by:0x4c1d
ID: 36576468
Hi i found useing this method when trying to open protected excell files useing parameter %1 for all file type of Excel in the “OPEN” settings of Explorer file associations as follow.

Launch “Windows Explorer”
Click Menu Tools -> Folder Options
Click Tab “File Types”
Select item XLS in the list
Click Button “Advanced”
Select Open in the list
Click button “Edit”

Then add “%1” after /e in the box “Application used to perform action:”

If this wont work try adding in the addin "Lookup Wizard", this automagicly fixs every thing

thanks

0
 

Accepted Solution

by:
networkn earned 0 total points
ID: 36580345
I actually managed to find and disable protected view and this solved the problem, question is how to determine the cause of the hang next.
0
 
LVL 18

Expert Comment

by:awawada
ID: 36585277
Is Windows and Office up to date?
0
How does your email signature look on mobiles?

Do your employees use mobile devices to reply to emails? With mobile becoming increasingly important to the business world, it is in your best interest to make sure that your email signature looks great across all types of devices.

 
LVL 2

Expert Comment

by:0x4c1d
ID: 36585643
i think this is what you are after,

it a programme called windbg - its a crash memory dump analyst tool

http://msdn.microsoft.com/en-us/windows/hardware/gg463016

this will give you a detailed report on what caused the crash when any crash happens

thx
0
 

Author Comment

by:networkn
ID: 36972588
Hi There!

Ok well I disabled protection from Excel, same thing now happening with Word. It's not crashing. It's just hanging saying opening protected file.
0
 
LVL 50

Expert Comment

by:teylyn
ID: 37412254
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

706 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

18 Experts available now in Live!

Get 1:1 Help Now