The way we have the spreadsheet setup now is that all six people can open and edit it. Then when one person saves it will update any cells that another person may have saved in.
I agree with you that excel is being stretched to it's capabilities and we need to move to something different that won't be such an issue. Looking into sharepoint to see what would work within that. Access would be a last ditch effort, since I really don't want to deal with those headaches quite yet. _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected] | www.aurico.com From: Brian Desmond [mailto:[email protected]] Sent: Thursday, June 24, 2010 2:00 AM To: NT System Admin Issues Subject: RE: Shared spreadsheet freezes Sensitivity: Confidential 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] | www.aurico.com ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
