Solved

Get Read-Only or Notify Message whenever spreadsheet is reopened within Excel 2003

Posted on 2006-11-04
5
664 Views
Last Modified: 2008-03-06
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
0
Comment
Question by:GMartin
  • 3
  • 2
5 Comments
 
LVL 27

Assisted Solution

by:Dabas
Dabas earned 500 total points
ID: 17875104
Hi George,
This message appears when your Excel workbook is already open. If you are the only user, then probably the best course of action is to choose Cancel and look at your task bar on the bottom of your screen (to the right of the Start button), to select your open workbook

The message is useful in a shared environment. Excel is trying to avoid you and an other user making different changes to the same workbook at the same time


Dabas
0
 
LVL 27

Accepted Solution

by:
Dabas earned 500 total points
ID: 17875109
... continued

Read Only means: "I want to open this workbook to have a look at it, but will not make any changes, or if I do, I will rename the sheet"
Notify means: "Please let me know when the other user has closed his copy of the workbook, so that I can save my changes"
Cancel means: "Forget it, I will open it later"

Dabas
0
 

Author Comment

by:GMartin
ID: 17875116
Hi

       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
0
 
LVL 27

Expert Comment

by:Dabas
ID: 17875129
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
0
 

Author Comment

by:GMartin
ID: 17877591
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
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to restrict a file from copy/edit/save/print/saveas? 8 86
Any free software for printscreens 7 97
PCAnywhere 2 136
Moving files from folder to folder 8 43
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question