Posted on 2012-09-05
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 will just confuse them.

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

    Assisted Solution

    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

    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.
    LVL 4

    Author Comment

    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

    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

    If you have this option, it doesn't give any message about read-only or who has it open.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    There is a question posted at ( and i…
    Read about achieving the basic levels of HRIS security in the workplace.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now