Issue Opening a file in Excel


  • Experiencing a "lock" problem when opening an Excel File resident on Office365 SharePoint Online (Busuiness Premium License). When opening a specific Excel File, that is password protected, receive the message "This file is locked for editing by another user" (Excel 2016 on Windows 7) after the possword is successfully entered. The file does not show as checked out in SharePoint. This file is one of 20 or so password protected excel files in the same SharePoint library and none of the other files exhibit this issue. I've read that there are locking issues when opening a shared Excel File in Windows 7. Wondering if anyone else has experienced this problem and what was done to rectify it?
    Friday, February 12, 2016 2:23 PM