Excel itself set password to file


  1. Posts : 37
    Windows 10
       #1

    Excel itself set password to file


    Hi,
    User in company used one excel file. She closed it and wanted to open some minutes later, but was shocked, that it asks for password to open it. She didn't set any security to this file, she even don't know ho to do that.
    Any info, how this could happen? Is it possible, that excel itself set password protection to file?
    p.s. She is using Office 365.

    Thanks.
      My Computer


  2. Posts : 16,949
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #2

    sandisk said:
    Is it possible, that excel itself set password protection to file?
    No.

    sandisk said:
    Any info, how this could happen?
    Please post a screenshot of Excel asking for a password for that file.
    - The cause must be either that the user set the password or there is a very, very strange form of file corruption taking place.
    - I have heard of scripts for scanning computers to list password-protected files. Perhaps running one of these would confirm / reject the notion that a real password has been set???
    - Is there any VBA in that Excel file? Any reference to .Protect in it [such as ActiveWorkbook.Protect]?

    Denis
    Last edited by Try3; 04 Feb 2020 at 12:37.
      My Computer


  3. Posts : 37
    Windows 10
    Thread Starter
       #3

    It is standard password protected excel view.
    Excel itself set password to file-2020-02-04-17_57_15-excel.png
    Regarding user, don't think she is able to set password. And this can't be done accidentally, as it asks for password, than password confirmation.
    Very strange, luckily this file isn't too important.
      My Computer


  4. Posts : 16,949
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #4

    I have found a PowerShell script for scannning your documents to find out if any other files have been affected.

    Find a password-protected Office file - SpiceWorks forum

    I have not yet tested this script.


    I cannot get this script to operate properly. It does not detect my test files.

    Denis
    Last edited by Try3; 04 Feb 2020 at 11:42.
      My Computer


  5. Posts : 5,899
    Win 11 Pro (x64) 22H2
       #5

    sandisk said:
    Hi,
    User in company used one excel file. She closed it and wanted to open some minutes later, but was shocked, that it asks for password to open it. She didn't set any security to this file, she even don't know ho to do that.
    Any info, how this could happen? Is it possible, that excel itself set password protection to file?
    p.s. She is using Office 365.

    Thanks.
    Sorry, but Excel doesn't just password protect itself. It takes active confirmation steps to accomplish this. Not saying the file isn't password protected, just saying someone "had" to setup a password.

    And yes, I'm currently using Office 365.
      My Computers


  6. Posts : 37
    Windows 10
    Thread Starter
       #6

    Hi sygnus21,
    Yes that's what I think too, it can't be done
    accidentally and there are no shortcut keys to set password.
    Hope it was some strange bug and there won't be more cases like this.
      My Computer


  7. Posts : 16,949
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #7

    I hope your backup method retains previous copies as well as last modified ones in case you have an employee with a grudge or a hacker who intends to hold you to ransom.

    Denis
      My Computer


  8. Posts : 37
    Windows 10
    Thread Starter
       #8

    Important files should be stored to file server, where files are backup'ed. Local stored files are not protected.
      My Computer


  9. Posts : 1,656
    Windows 10 Pro x64
       #9

    sandisk said:
    Hope it was some strange bug and there won't be more cases like this.
    Highly doubtful it is a bug, actually near impossible - if it was, there would have been many reports about this.

    I think its more likely the user made a mistake in creating the password, and is too embarrassed to admit it.
      My Computers


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 18:57.
Find Us




Windows 10 Forums