GMartin
asked on
Get Read-Only or Notify Message whenever spreadsheet is reopened within Excel 2003
Hi Everyone:
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.
Thank you.
George
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.
Thank you.
George
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
George:
I just reread your original post, and need to clarify exactly what is happening, since you mention this happens when you save and close.
Do I understand correctly that you are proceeding like this
Start Windows, with nothing running
Open Excel
Open Inventory.xls
Make changes
Save Inventory.xls <--- Message appears?
Or is the sequence different?
Dabas
I just reread your original post, and need to clarify exactly what is happening, since you mention this happens when you save and close.
Do I understand correctly that you are proceeding like this
Start Windows, with nothing running
Open Excel
Open Inventory.xls
Make changes
Save Inventory.xls <--- Message appears?
Or is the sequence different?
Dabas
ASKER
Hi There:
Thank you so much for clarifying what I occasionally see. Knowing exactly what this message means now is certainly reassuring when opening and closing Excel 2003.
As you notice, I spit up the points because I found both of your answers germane to this post.
Thanks again for your help.
George
Thank you so much for clarifying what I occasionally see. Knowing exactly what this message means now is certainly reassuring when opening and closing Excel 2003.
As you notice, I spit up the points because I found both of your answers germane to this post.
Thanks again for your help.
George
ASKER
Thanks so much for the followup. Since I am the only person working on this spreadsheet and I want to make this project just one file name, which option should I select without loosing my previous work?
George