Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2006-11-04
5
Medium Priority
?
684 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 2000 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 2000 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The main intent of this article is to make you aware of ‘Exchange fail to mount’ error, its effects, causes, and solution.
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

670 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