Solved

Excel 2010 hangs opening Protected Files

Posted on 2011-09-21
7
2,301 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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:Ingeborg Hawighorst
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Find out what you should include to make the best professional email signature for your organization.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

863 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

26 Experts available now in Live!

Get 1:1 Help Now