ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   closing file with multiple windows open (https://www.excelbanter.com/excel-worksheet-functions/118914-closing-file-multiple-windows-open.html)

gvanhoy3

closing file with multiple windows open
 
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

closing file with multiple windows open
 
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


All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com