Solved

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

Posted on 2006-11-04
5
672 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Cognitive Services 1 74
Bulk Reorder File Names 4 88
CPU at 100% usage, why? 27 165
Password Management 4 54
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

739 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