file in use

Cablek

Board Regular
Joined
Nov 22, 2017
Messages
51
my excel workbook says it's locked for editing by "userxx" but that user doesn't have it open.

is there a way to force the workbook to close

using Windows 10
Microsoft office 365
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
The user may have it open through a data connection.
Otherwise, the file was not completely closed and saved by the OS before you opened it. This may need a restart of any or all the computers that have a connection to the file, including the computer the file resides on...
 
Upvote 0
ok thanks SpillerBD I will give it a try tomorrow AM as the file it resides on is a Qnap and many users use it during the day.



The user may have it open through a data connection.
Otherwise, the file was not completely closed and saved by the OS before you opened it. This may need a restart of any or all the computers that have a connection to the file, including the computer the file resides on...
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,315
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top