Think that's bad, this whole company is run on excel spreadsheets. We deal with corrupt spreadsheets on a weekly basis.
We have a few Access databases with over 40 simultaneous users, and they wonder why it runs slow. Things are very slow to change about here. Regards Tony Patton Desktop Operations Cavan Ext 8078 Direct Dial 049 435 2878 email: [email protected] From: Kevin Lundy <[email protected]> To: "NT System Admin Issues" <[email protected]> Date: 24/06/2010 13:51 Subject: Re: Shared spreadsheet freezes 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 This e-mail is intended only for the addressee named above. The contents should not be copied nor disclosed to any other person. Any views or opinions expressed are solely those of the sender and do not necessarily represent those of QUINN-Insurance Limited (Under Administration), unless otherwise specifically stated . As internet communications are not secure, QUINN-Insurance Limited (Under Administration) is not responsible for the contents of this message nor responsible for any change made to this message after it was sent by the original sender. Although virus scanning is used on all inbound and outbound e-mail, we advise you to carry out your own virus check before opening any attachment. We cannot accept liability for any damage sustained as a result of any software viruses. ==================================================================== QUINN-Insurance Limited (Under Administration) is regulated by the Financial Regulator and regulated by the Financial Services Authority for the conduct of UK business. ==================================================================== QUINN-Insurance Limited (Under Administration) is registered in Ireland, registration number 240768 and is a private company limited by shares. Its head office is at Dublin Road, Cavan, Co. Cavan. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
