Office Software Thread, Password protecting spreadsheets with macros in Technical; Hi,
I have a spreadsheet in .xlsb format which is protected with 'password to open' to which I want to ...
18th April 2013, 11:44 AM #1
- Rep Power
Password protecting spreadsheets with macros
I have a spreadsheet in .xlsb format which is protected with 'password to open' to which I want to add a Excel 4.0 macro worksheet.
I know that I can save it as .xls and add the macro sheet, however, I am unsure if this will compromise the level of encryption provided.
Searching the internet I can't find a definitive answer as to whether the level of encryption is linked to the version of Excel used to save the file, or the document format used.
Please could someone advise me as to whether saving as a .xls will lead to the file becoming no longer secure.
24th April 2013, 10:33 AM #2
- Rep Power
Answer to my own question
Plan cryptography and encryption settings for Office 2013
"If you have to encrypt Office documents, we recommend that you save the documents as Open XML Format files (.docx, .xlsx, .pptx, and so on) instead of Office 97–2003 format (.doc, .xls, .ppt, and so on). The encryption that is used for binary documents (.doc, .xls, .ppt) uses RC4. It isn’t recommended, as discussed in Security Considerations sections 4.3.2 and 4.3.3 of the Office Document Cryptography Structure Specification. Documents that are saved in the older Office binary formats can only be encrypted by using RC4 to maintain compatibility with older versions of Office. AES, the default and recommended encryption algorithm, is used to encrypt Open XML Format files."
Though this does still leave me wondering how I am to save documents securely with macros, but I suppose the answer is simply that I am not.
Thanks to schoolDataManager from:
LosOjos (24th April 2013)
24th April 2013, 10:36 AM #3
Thanks for sharing
Originally Posted by schoolDataManager
I would assume from that info that saving as XLSB would be the most secure as that is part of the newer Open XML format and so should use AES encryption
By ryan_powell in forum Web Development
Last Post: 31st January 2008, 02:52 PM
By StewartKnight in forum Hardware
Last Post: 6th November 2007, 10:51 AM
By binky in forum Wireless Networks
Last Post: 30th August 2007, 03:36 PM
By sqdge in forum Windows
Last Post: 31st July 2007, 03:47 PM
By Uraken in forum Windows
Last Post: 21st February 2007, 12:42 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread