If protecting workbook in ms excel (2010, 2007, 2003) is enough safe for a sensitive data? There is a possibility to choose encryption aes 128 bit in ms excel 2003 and 2007 (as default), from that what I read there is a possibility to choose aes 256 bit in ms 2010. But if I choose aes 256 bit in ms excel 2010., if I would have a possibility to open in ms excel 2007/2004? There are available some special applications to open protected Excel files, they work for sure with ms excel 2003. How it is with newer version of excel? How long should be password? 20 characters would be enough for workbooks with sensitive data?
migrated from stackoverflow.com Jul 26 '12 at 7:56
This question came from our site for professional and enthusiast programmers.
No data in excel is safe.
I can easily bypass / remove / reveal any passwords in the workbook, worksheet, or VBA level.
(for less than 100$ -last time i checked- a person can buy a commercial application that does the same thing)
If you're trying to restrict access permissions to a portion of the data, try separating the data into a secure and insecure workbooks and keeping the secure workbook in a location that only certain users can access.
And I dont think that using encryption features unique to a later version of office would make it backwords compatible... If this is something that you need to use across yoru cases, then this is something you can easily test for.. (by trying it out)