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. Try3's Avatar
    Posts : 7,380
    Windows 10 Home x64 Version 20H2 Build 19042.868
       #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 11: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. Try3's Avatar
    Posts : 7,380
    Windows 10 Home x64 Version 20H2 Build 19042.868
       #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 10:42.
      My Computer

  5. sygnus21's Avatar
    Posts : 5,304
    Win 10 Pro (x64) 20H2 (19042.906)
       #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. Try3's Avatar
    Posts : 7,380
    Windows 10 Home x64 Version 20H2 Build 19042.868
       #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. Golden's Avatar
    Posts : 1,635
    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 02:59.
Find Us




Windows 10 Forums