So I thought for some reason Excel didn't let you do some sort of row level locking e.g. if one guy opens the spreadsheet then the others are in read-only?
In any case this is either a) an Excel issue or b) a server issue. When the file grows in size you've got file system level locking on the server side and depending if something is hosed up on the file server you might just be causing little hangs like this that Excel handles poorly. All that said I'd agree with others that your customer is stretching the purpose of Excel a bit and they ought to get some sort of solution a bit more designed for this. SharePoint might work or Access (as much as a disaster as that can be). Thanks, Brian Desmond [email protected] c - 312.731.3132 From: Cameron Cooper [mailto:[email protected]] Sent: Wednesday, June 23, 2010 11:34 AM To: NT System Admin Issues Subject: Shared spreadsheet freezes Sensitivity: Confidential We have a research dept. that uses an Excel spreadsheet to enter in which orders are assigned to different researchers. Currently the spreadsheet is shared between 6 people (which all have it open and make changes to it throughout the day) and is stored on a network drive. The issue is throughout the day the spreadsheet grows in file size, which in turn causes it to freeze or crash. Without using google apps or office apps online, is there another method that we can use (ie Access, sharepoint)? _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected]<mailto:[email protected]> | www.aurico.com ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
