Inactivate an add-in that's causing the lock. Then uncheck Refresh data when opening file. Select the table or PivotTable, then go to Table Tools Design > Refresh > Connection Properties. Turn off the Refresh data when opening file setting on all tables and PivotTables in the file. Go to File > Info > Protect Workbook and remove any passwords or restricted access settings. If possible, remove password encryption or restricted access from the file. If those two solutions don't work, try one or more of the following. Also, if you are opening a snapshot from SharePoint, open the workbook itself instead.
The first thing to try is to turn off the Shared Workbook feature. Ask the person who has the file open to do one or more of the following. To open the hidden Application Data folder.If you are trying to co-author, the “locked” error can occur if the file uses a feature that is not supported by co-authoring. To open temporary files folder, or Explorer %appdata% To open current user profile folder when opening File Explorer, or Explorer %temp% For example, I can use Explorer %userprofile% You can also use environment variables to quickly open folders in File Explorer. If I really do this often enough, I can create a shortcut on the desktop with the same command. Press Win + R, and enter explorer c:\users\info\OneDriveįile Explorer opens up with my OneDrive files listed right in front of me. For example, I want to see what’s in my OneDrive when I open File Explorer, here is what I can do. Here is a trick that you can use if that’s the case. Now, every time you open File Explore, This PC becomes the default location you see.īut what if This PC is still not something I like to see every time I open File Explorer? Then change Open File Explorer to option to This PC. Go to File → Change folder and search options, The default opening location in File Explorer in Windows 10 is something called Quick Access, a new feature that gathers all frequently used folders and files in a single place for easy access.īut what if I don’t like the idea of Quick Access? What about This PC?
0 kommentar(er)
