I noticed each time I save and close the spreadsheet within Excel 2003, I get the following message: Inventory.xls is locked for editing by George Martin. Open 'Read-Only or Click Notify to open read only and receive notification when the document is no longer in use. There are three options on the side labeled Read Only, Notify, and Cancel respectively. I have been selecting Notify because this worksheet is an ongoing process. However, I am unclear on what this message really means and also which option should be selected. Hopefully, I selected the right one.
Any shared thoughts regarding this question will be appreciated.