Shared workbook showing as read only

B

billyvan

New Member
Joined
May 22, 2007
Messages
29
I have a shared excel 2003 workbook and upon opening it advises that the file is in use, locked for editing and gives me the option to open the file as a 'read only' file. All users who have access to this workbook are not viewing the file and it has been in this state for 4 days. I have checked the properties of this file and the 'Read Only' box is not checked.

Could someone please help me out with how I can unlock this file

Thanks
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
thanks stormseed.

I haves een these links and they more or less tell me how to set it up but not how to rectify this issue. Also as I can only open the file as read only I cannot update the share workbook options.
 
Upvote 0
Are you sure the file is not opened by anyone else on the network ?

Least you could try to end the process tree of Excel on Windows --> Reboot your computer and try to access it again. Just do it and see what happens. Let us know the outcome, we could try some more things to rectify the issue.
 
Upvote 0
Hi Stormseed

There was some maintenance done on the network which required a bounce of the server which has cleared the lock on this workbook.

Thanks for your help with this.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Solved
Macro on server based workbook runs fine for me & colleague, but run-time errors for another colleague
Replies
7
Views
449
PerseveringHarold
P
R
  • Question
Is there a way to open a file that Power Query has locked as Read-Only?
Replies
0
Views
82
rcrumbliss
R
K
  • Question
How to Use "GetPivotData" formula to retrieve data from a closed workbook
Replies
3
Views
270
RoryA
RoryA
A
  • Question
Excel Crashing after SaveAs
Replies
0
Views
185
ampd
A
E
  • Question
hyperlinks path changes without notice in a excel workbook
Replies
3
Views
219
jkpieterse
jkpieterse

Forum statistics

Threads
1,214,622
Messages
6,120,576
Members
448,972
Latest member
Shantanu2024

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