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?
|