We have several Excel workbooks that are stored on network drives within the office.
We have sharing turned on each of these workbooks.
Multiple users access these files, leave them open all day, edit, etc.
The files freeze often, stop responding, don't open, hang, etc. (All other Excel documents that are not shared perform normally)
We experience a host of issues and need to know
A. Is there a better way?
B. Are we missing how to set-up these shared workbooks. Should we alter settings?
We are using Office 2010 although several of the files are in 2003 version.