We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

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

GMartin
GMartin asked
on
Medium Priority
713 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
Comment
Watch Question

CERTIFIED EXPERT
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
CERTIFIED EXPERT
Commented:
... 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

Author

Commented:
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
CERTIFIED EXPERT

Commented:
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

Author

Commented:
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.