Sue Taylor
asked on
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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.