• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

SHARING EXCEL FILE ON NETWORK

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?
0
ITworks
Asked:
ITworks
  • 3
3 Solutions
 
pony10usCommented:
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.
0
 
mark_harris231Commented:
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.
0
 
ITworksAuthor Commented:
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)
0
 
mark_harris231Commented:
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.
0
 
mark_harris231Commented:
If you have this option, it doesn't give any message about read-only or who has it open.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The IT Degree for Career Advancement

Earn your B.S. in Network Operations and Security and become a network and IT security expert. This WGU degree program curriculum was designed with tech-savvy, self-motivated students in mind – allowing you to use your technical expertise, to address real-world business problems.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now