Hi guys one of our users is having trouble saving & opening password protected xlsx files in Excel. This has only just started happening yesterday.
The errors are:
"Excel cannot open this file. The encryption type used is not available, contact the author of the files. More encryption types are available using the High Encryption Pack"
"Excel is unable to encrypt your file. Please contact your system administrator to resolve this problem. Do you wish to remove encryption and try again? "
It is doing this no matter where the file is, network share, desktop, my documents etc. With different files & new files so it's not just limited to one file.
I've tried opening Excel in safe mode still no joy.
I've also tried logging in as me on the problem PC & I can open the files & save new password protected files fine. Also no one else on the network is having this issue.
I've also tried logging the user in on a different machine & there's no problems there either.
This problem has got me rather baffled & I've drawn a blank on Google so hopefully someone can help me?
I also tried doing an Office repair & still no luck
Oh also the machine is fully patched.
- Moved by Jennifer ZhanModerator Wednesday, November 03, 2010 5:49 AM (From:Office 2010 Application Compatibility)
I guess this issue is related to the permissions of this user. Your user maybe has lost ownership of those files & folders or it no longer has the required permissions. If so, try following method:
First, navigate to that problem Excel file, right click on it and select Properties.
In the Properties window go to the Security tab and click on Advanced.
Now go to the Owner tab. Here you will see the current owner of that file. If your user is not the owner, click on Edit. If you have User Account Control enabled, press on OK.
In the Owner window, click on Other users or groups. Now you need to type the user name or the group of users that will take ownership of the selected folder. If you type "Administrators" you will give ownership to all the users that are administrators on your PC. If you want to give ownership only to your user, then type your user name. After that, press on Check Names.
If the user or group was found on your computer, you will see that the text you typed was changed to [Your PC Name]\[User] or [Your PC Name]\[Group]. If so, press on OK.
If the user/group was not found you will receive a Name Not Found error window. Make the necessary corrections and try again.
In the Owner window, select the user/group you just added, select Replace owner on subcontainers and objects and press OK.
Now you will receive the confirmation that you have taken ownership of the folder. Press on OK and that's it.
Hope that helps.
I'll try it but but all the permissions are set by AD.
Also she can't save brand new password protected excel files anywhere either (desktop, my docs etc) but she can save normal Excel files (and any other type of file for that matter).
The really weird thing is if we try to save a new blank password protected Excel file in the old xls format it works.
Also just thought to have a look in the event viewer (why i didn't do this sooner i don't know) and found the below which occurs when trying to save or open passworded files.
Log Name: Application
Source: Microsoft Office 14
Date: 11/3/2010 3:37:08 AM
Event ID: 2010
Task Category: None
CAPI Create Key Error: 0x80070057, CngCipherAlg: AES, Prov: Microsoft Base Smart Card Crypto Provider, ProvType: 1, Algid: 0x0000660e, KeyBits: 128, Block size: 0, Hash size: 20
<Provider Name="Microsoft Office 14" />
<TimeCreated SystemTime="2010-11-03T08:37:08.000000000Z" />
<Data>CAPI Create Key Error: 0x80070057, CngCipherAlg: AES, Prov: Microsoft Base Smart Card Crypto Provider, ProvType: 1, Algid: 0x0000660e, KeyBits: 128, Block size: 0, Hash size: 20</Data>
Oh forgot to mention the machine in question is in a remote office, so I'm slightly limited by what i a can try :(
I'm half tempted to try removing her profile & see if that solves it, as anyone else that uses that machine is ok & if i log in as her on another PC it's also fine.
I am having the same issue on my network. In my case I am able to pin point the problem to a settings change that the user made inside Excel 2010. I have been playing around with the settings with no luck. I recommend that you check the settings and look for a section where you can change the encryption or password preferences on XLSX files. If I am able to find the section I will post it here shortly.
I am having the same issue on my network. In my case I am able to pin point the problem to a settings change that the user made inside Excel 2010. I have been playing around with the settings with no luck. I recommend that you check the settings and look for a section where you can change the encryption or password preferences on XLSX files. If I am able to find the section I will post it here shortly.Hrm yeah i think it's got to be a setting she has changed somewhere or something has gone wrong with her profile on this machine. Just need to try & find what or where...
Hmm no it's not a 'setting'. This has happened for me ever since I upgraded to 2010, a couple months ago. Other users with 2010 can save encrypted files just fine, but I cannot. I'm a Domain Admin so it has nothing to do with permissions or any of that ____.
This is a problem with Excel that Microsoft needs to sort out. I'm F**KING sick of constantly searching for workarounds for Microsoft Products
Solution is simple.. you just need to install the SP22007 Microsoft Office Suite Service Pack 2
I am also having the same issue since i upgraded from WIN XP to WIN7 on my office laptop.
My password protected excels from XP are not opening on Win7 & also I am unable to create new files with password protection on Win7.
Checked at all forums, but there is no solution available for this.
Internally raised a ticket with my IT folks. They also failed to fix this & eventually suggested me to install Openoffice.
My Office 2010 is up to date with all service packs & hot fixes applied.
Time to wake up Microsoft. Just FYI - I am submitting this post from my Chrome browser.
check the properties for the worksheets and then make sure you have read/write permission
use an administrator account to change permissions
Corsair Carbide 300R with TX850V2
Asus M5A99FX PRO R2.0 CFX/SLI
AMD Phenom II 965 C3 Black Edition @ 4.0 GHz
G.SKILL RipjawsX DDR3-2133 8 GB
EVGA GTX 660 Ti FTW Signature 2 (GK104 Kepler)
Asus PA238QR IPS LED HDMI DP 1080p
ST2000DM001 & Windows 8.1 Professional x64
Microsoft Wireless Desktop 2000 & Wacom Bamboo CHT470M
Place your rig specifics into your signature like I have, makes it 100x easier to understand!
Hardcore Games Legendary is the Only Way to Play!