Solved

Can't open Excel or Word file in green text - permission problem?

Posted on 2014-04-11
12
3,588 Views
Last Modified: 2016-10-01
Hi,

I'm trying to restore and open files from my old laptop. In one particular folder, I can open every file except 2. One is a Word document, and the other is an Excel document. Both were created using version 2010. It's strange, but both file names show up in green text. All the others are in black text, as usual.

When I try opening the Excel doc, I  get the message:

"Excel cannot open the file 'Payroll_Budget.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

When I try to open the Word doc, I get the message:

Word cannot open the document. user does not have access privileges."
0
Comment
Question by:Go-Bruins
  • 6
  • 5
12 Comments
 
LVL 16

Expert Comment

by:l33tf0b
ID: 39995627
Green text in Windows Explorer if it's a file or folder means it's encrypted.  Right click on the file > properties > advanced > uncheck encrypt.  That's why you can't open it most likely.
0
 

Author Comment

by:Go-Bruins
ID: 39996560
I think that's close, but when I try to follow that procedure, I get "An error occurred applying attributes to the file: .... Access is denied.
0
 
LVL 16

Expert Comment

by:l33tf0b
ID: 39996757
Who's the creator or owner of said files?  If it was encrypted, you need the certificate to decrypt the file.  Most likely you need it from the original machine that the file was created on.  Contact the creator / owner of the file.  Have them decrypt the file.
0
 

Author Comment

by:Go-Bruins
ID: 39996868
What happens if the original laptop burned out?
0
 
LVL 16

Expert Comment

by:l33tf0b
ID: 39996881
If you do not have a backup of the key then you are out of luck.  you will not be able to recover any data without the certificate and key.

Unfortunately there is no known backdoor so if the owner of the files did not back up the keys / certs, you have no chance of recovering the data.
0
 

Author Comment

by:Go-Bruins
ID: 39998946
Thanks for your help. is the "Certificate" some kind of a file that can be moved from computer to computer? What format is it? and Where would I find them?
0
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!

 
LVL 16

Expert Comment

by:l33tf0b
ID: 39999317
On the original machine - open up mmc from start > run.  Add Certificates snap-in for users.

Refer to this link for all pertinent info:


http://technet.microsoft.com/en-us/library/cc875821.aspx

Follow the export Data Recovery Key section.
0
 

Author Comment

by:Go-Bruins
ID: 39999321
Assuming I don't have the orig laptop (but I do have the orig hard drive), can I just extract this data from the hard drive? maybe from a HD docking station? thx.
0
 
LVL 16

Accepted Solution

by:
l33tf0b earned 500 total points
ID: 39999350
If you can boot off the HDD, that would be the easiest way and run the mmc natively.  If not .... there's a possible solution listed below but much more intricate.


http://social.technet.microsoft.com/Forums/en-US/089f358d-68f1-426c-a6a6-0fa52ad274d3/import-efs-key-directly-from-xp-systemcertificates-folder?forum=w7itprosecurity


Posted thread below:


I know the topic is old, but I was in the same situation right now, trying to recover data of one my customers.
The old computer was no longer bootable, the HDD was dying, exporting encryption certificate from old machine was no longer an option.
However, I was able to access and backup following folders from the old HDD:

c:\documents and settings\{username}\application data\microsoft\crypto\
c:\documents and settings\{username}\application data\microsoft\protect\
c:\documents and settings\{username}\application data\microsoft\systemcertificates\

then i found this article with detailed instructions that helped me to decript my files: http://www.beginningtoseethelight.org/efsrecovery/
the article is quite comprehensive, i will try to summarize the basics steps you need to do:
1) get copy of the above 3 directories from the old machine
2) identify SID of your old machine and user:
Quote from original article:

"you will need a user account of the same user and machine number as the orginal. check this orginal folder name: c:\documents and settings\%username%\application data\microsoft\crypto\rsa\s-1-5-21-1078081533-1606980848-854245398-1003

machine is: 1078081533-1606980848-854245398
useracc is (user-id): 1003"

3) download NewSID (http://www.chip.de/downloads/NewSID_21127671.html), download from microsoft is no longer available :(
4) run NewSID and set your machine SID to the old one, reboot
5) Make sure that your user-id, name and password are identical to the old one
Quote from original article:
"encrypt a test file, then browse to c:\documents and settings\%username%\application data\microsoft\crypto\rsa\ - is the number on the end of the sid eg 1003 the same as the previous number?"
if it is the same, skip to 6) otherwise see article
6) copy above 3 folders into your current profile, overwrite everything
7) reboot
8) now you should be able to access encrypted files.
all credits go to "clark", who wrote the mentioned article.
0
 

Author Closing Comment

by:Go-Bruins
ID: 39999353
Tremendous. I wish I could give you 5000 points :)
0
 
LVL 16

Expert Comment

by:l33tf0b
ID: 39999589
appreciate it, glad everything is working out.
0
 

Expert Comment

by:Payal Bharad
ID: 41824690
When I try to open word and excels file its signboard open "Access Denied" What should I do?
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Microsoft Office 2010 is Microsoft's latest edition to their office productivity collection. It "promises to include rich and powerful new ways to deliver your best work". So to start off, I have to say that I'm slightly disappointed... That bei…
In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site (Experts-Exchange.com in my example), with minimal effort in Chrome and Firefox. I've seen a common theme a…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

743 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

15 Experts available now in Live!

Get 1:1 Help Now