Posted on 2012-09-05
Medium Priority
Last Modified: 2012-09-05
I want to share an Excel file on the network.  I would like to be able to have it open up READ ONLY but not alert the user that it's opening up to READ ONLY.  Also, since this is on the Network, if someone has this opened up, I'd like to it NOT to notify any other user that may open it up.  

The file is used to calculate piece price for our sister company.  I want the user to be able to go in and enter the quanity, size and length and get their piece price.  It's sad to say, but if they get questions asking them to open as read only, or to be notified when it's ready....it will just confuse them.

Does anyone have any ideas on how I can accomplish this?
Question by:ITworks
  • 3
LVL 26

Assisted Solution

pony10us earned 668 total points
ID: 38369437
To achieve the first part you could go the file and right click. Select properties and place a check mark in the read only attribute and save it. That should not notify the user unless they attempt to save it.
LVL 10

Expert Comment

ID: 38369570
Presumably, you also only want them to be able to select & enter data in specific cells.  You can accomplish this by formatting the cells you want them to be able to select as not Locked (uncheck the Locked checkbox in the Protection tab), then Protect & Share the Worksheet.

Author Comment

ID: 38369929
Yes, Mark_Harris231, I understand about that BUT......when userJOHNDOE has this file open and userJANESMITH opens it up, will she get a popup saying that userJOHNDOE has this file open, do you want to open as Read Only, or be notified when it's available for editing, etc. ( I forget the verbiage of this popup)
LVL 10

Accepted Solution

mark_harris231 earned 1332 total points
ID: 38370071
What version of Excel?  In 2007 & 2010, you can enable the option to "Allow changes by more than one user at the same time" when you share the workbook.
LVL 10

Assisted Solution

mark_harris231 earned 1332 total points
ID: 38370118
If you have this option, it doesn't give any message about read-only or who has it open.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

850 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