file in use

C

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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
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.



SpillerBD said:
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...
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

starl
  • Question Question
File In Use - reboot doesn't work
Replies
6
Views
293
starl
starl
P
  • Solved
Disable 'X' on Worksheet
Replies
4
Views
115
Pacman52
P
S
  • Question Question
Is there a way to open a workbook, refresh everything and close after success.
Replies
1
Views
690
severynm
severynm
N
  • Question Question
Slow vba with opening 60 files
Replies
7
Views
269
NickvdB
N
O
  • Question Question
How to automatically recalculate all workbooks in a office 365 spreadsheet each time its opened without using vba or macros.
Replies
5
Views
309
felixstraube
F

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

Share this page

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