We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

How secure is an Excel password protected file?

RG2015
RG2015 Posts: 6,209 Forumite
Tenth Anniversary 1,000 Posts Name Dropper Photogenic
edited 20 December 2017 at 5:46PM in Techie Stuff
There is a thread on the banking board discussing password protected Excel files with an ongoing difference of opinion.

So my question is, how easy is it to access a password protected Excel file without knowing the password?

I have Excel 2016 so I am not too concerned with earlier releases which I understand are less well encrypted. The thread started out questioning the security of Google Drive but strayed a bit at post #10 to the Excel issue.

https://forums.moneysavingexpert.com/discussion/5761920
«1

Comments

  • Neil_Jones
    Neil_Jones Posts: 9,763 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    Excel 2016 uses the same type of encryption technology as a lot of Ransomware does, which makes it fairly secure if your password is long and complex enough (ideally 32+ characters and some special characters - brackets, ampersands, etc) - Brute force and dictionary attacks are always possible. Of course remember your password!
  • John_Gray
    John_Gray Posts: 5,847 Forumite
    Part of the Furniture 1,000 Posts Name Dropper Photogenic
    You could get an idea how secure are the documents and spreadsheets in versions of Office since about 2003 by searching for password crackers for these.

    Good luck in finding any...
  • Choose a three-word pass-phrase like GreekSucceedCook and input it using the on-screen keyboard to defeat keyloggers.
  • AndyPix
    AndyPix Posts: 4,847 Forumite
    Fifth Anniversary 1,000 Posts Name Dropper Photogenic
    edited 21 December 2017 at 10:22AM
    John_Gray wrote: »
    You could get an idea how secure are the documents and spreadsheets in versions of Office since about 2003 by searching for password crackers for these.

    Good luck in finding any...


    Before 2013 they were very insecure ..


    But even now, Dont be too sure that your IT dept cant crack your document


    https://blogs.technet.microsoft.com/office_resource_kit/2013/01/23/now-you-can-reset-or-remove-a-password-from-a-word-excel-or-powerpoint-filewith-office-2013/
  • AndyPix wrote: »
    But even now, Dont be too sure that your IT dept cant crack your document
    One would expect IT to have access to password protected company documents without the password.

    If an employee gets run over by a bus, their password protected company documents should not become completely inaccessible to the company.

    This does have the downside (depending on your point of view) that if people sneakily do personal stuff at work using the company copy of Office, IT can see their protected documents.
    Proud member of the wokerati, though I don't eat tofu.Home is where my books are.Solar PV 5.2kWp system, SE facing, >1% shading, installed March 2019.Mortgage free July 2023
  • Choose a three-word pass-phrase like GreekSucceedCook and input it using the on-screen keyboard to defeat keyloggers.
    You should really insert some special characters into these too
  • JohnB47
    JohnB47 Posts: 2,719 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    I remember last year receiving a spreadsheet as an aid to working out a financial proposition. I was curious as to how some of the calculations were made, so I Googled to see if I could break into it. It was very easy.

    I can't remember the detail now but it involved doing something to the original then applying a password - perhaps it was the original password or maybe a new one. Took me about 15 minutes in total and worked perfectly.

    Let's face it, everything can be broken into - it's only a matter of time, effort and perceived reward.
  • googler
    googler Posts: 16,103 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Combo Breaker
    Open an Excel spreadsheet with Notepad or a similar text editor, and you can see loads of content, probably every text and number field at least..

    Note sure how easy it would be to use it, that would depend on the sheet, and how 'keen' the opener was....
  • >You should really insert some special characters into these too<

    Doesn't increase the entropy of a 3-word pass-phase by any meaningful amount and increases tendency to write the passphrase down.
  • Having used those files for years I would support the view that the passwords are fine for protecting work from inadvertent modification.
    I would not recommend to secure personal or financial details or important confidential or copyright work that is held within the public domain!

    In between, maybe after a risk assessment.....
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.6K Banking & Borrowing
  • 254.2K Reduce Debt & Boost Income
  • 455.1K Spending & Discounts
  • 246.7K Work, Benefits & Business
  • 603.1K Mortgages, Homes & Bills
  • 178.1K Life & Family
  • 260.7K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.