depending on how complex this spreadsheet is, Sharepoint may be a perfect solution.
On Thu, Jun 24, 2010 at 8:32 AM, Cameron Cooper <[email protected]> wrote: > 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/> ~
