I am tyring to open an excel file from NEEC. It is an energy compliance form used to evaluate energy usage in buildings. It opens easily in excel, without mention of encryption. But when I try opening in numbers all i get is the error message, "document encrypted and can't be opened"
Anyone passed this hurdle before?
MacBook Pro, Mac OS X (10.7.2)
If you can open in Excel maybe you can use "Save As..." to make a new file that is not encrypted. I got the same thing when I tried to open in Numbers.
As far as I know, it's not Apple duty to break the protection schemes delivered by M…oSoft.
Is M…oSoft delivering a way to open encrypted Apple's items ?
At this time, it doesn't deliver a way to open non encrypted ones 😟
Yvan KOENIG (VALLAURIS, France) dimanche 19 février 2012
iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3
My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k
I was able to open in LibreOffice, then save as and xls file and open in Numbers. I did not think it looked good in Numbers.
LibreOffice is a free open source Office clone. Google can help you find it.
thanks I will give it a shot. someone else suggested openoffice.org.
Here is a comment from one of the administrators of the energy code.
"The forms do not require a password to open, however there are several auto-calculating cells that are write protected. If you select one of these cell you will likely see a pop-up window requesting a password for access to this cell. All cells that you need to input information into are not write protected. I use a Mac as well and do not experience any problems filling out the forms."
I wish I could open it in Numbers.
Numbers does not support 'locked' cells, with or without passwords. Without the password requirement, it might open the file, but the 'locked' cells would not retain that property (or their current value, but not the formula, would be imported.
For now, at least, LibreOffice or OpenOffice.org appear to offer workable alternatives.
Regards,
Barry
Thanks Barry. I'll give em a try.
Hi
I can not comment specifically on NEEC, but:
I too have Excel files that are password protected to open and modify.
When I transfer this file from a PC (or a Mac) to another Mac, it does not open when i click on it, and gives the same message in this thread about encryption.
I solved it by going to Finder
Highlight/Select (don't double-click) the document in Finder
Go to "file" on finder menu bar
Go to "get info" on the drop-down list
Click on "open with"
Change the default from "Numbers" to "Microsoft Excel"
Click on your document
And you are away
You will of course have to have the relevant passwords
And I suspect, you can save back to Numbers
I hope this is useful to you
Thanks
Joe
This would probably work if I had excel.
I tried open office and it worked just fine.
thanks,
jm
Before I buy "numbers", kindly advise me from ur experiences, if I'll be able to open password protected excel files in iphone 4S? Many thanks in advance.
Numbers is unable to open password protected excel files.
Breaking M…oSoft protections isn’t Apple duty.
Yvan KOENIG (VALLAURIS, France) samedi 7 avril 2012
iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3
My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k
encrypted excel file will not open
