Maybe...

For #1:

http://contextures.com/xlfaqApp.html#ReadOnly
http://contextures.com/xlfaqApp.html#AlreadyOpen

For #2:
http://contextures.com/xlfaqApp.html#TwoWindows

All from Debra Dalgleish's site.

gvanhoy3 wrote:

I have opened a file in two windows. I have now saved and closed the file.
It is not shared. Someone else trys to open the file but gets the message
that I still have it open. Unless I completely shutdown excel, the file is
still locked by me.
Also, why when the file is opened later, does it show :2 at the end of the
file name? I only have one window open now.

This is excel 2002 XP.

--

Dave Peterson