Announcement

Collapse
No announcement yet.

Locked File error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Locked File error



    Hey guys! I have created a xls file using Excel 2016 that works perfectly on my Windows 8.1, but now when I’m opening it on Windows 10, it gives me ‘Locked File’ error. Why does Excel give me this pop up every time?
    Anyone have a solution for me?

  • #2
    With the file unopened in a folder, using windows explorer, right click on the file and select properties. Check the box Unblock ,

    Alan

    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

    If someone has helped you, say "thank you" by clicking on the Like Button.

    Comment


    • #3


      The first thing to check is that your date and time are set correctly.
      If that's set properly and you're still having trouble, the easiest way to fix it is to change an Internet Explorer setting (Ninite uses the same settings).
      Since Ninite runs as Administrator, you may need to log in as Administrator and change these settings for that account.
      1. Open Internet Explorer.
      2. In the Tools menu select Internet Options.
      3. Pick the Advanced tab and then scroll down to the Security section as pictured below.
      4. Then turn off or uncheck Check for server certificate revocation, highlighted below.
      5. Click OK at the bottom of the window
      More information: how to fix Excel errors

      Comment

      Working...
      X