View Single Post
  #5   Report Post  
Ken Wright
 
Posts: n/a
Default

Apologies if I'm missing something here, but can you not just open it up as
read only and then save a copy as a slightly different name, then just blitz
the old one and rename if you want? The file being locked would normally
only stop someone editing it, not opening it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Sandra" wrote in message
...
HELP!!!

I was in a file that's read only. My network connection crashed and now
nobody can get into my excel file because it says I have it locked. I see

no
temp file in the network folder that contains the file.

People are ready to kill me. What can I try?