Darryl Collins
darryl at whittleconsulting.com.au
Wed May 28 18:18:54 CDT 2014
Amen to this Bill. I always turn Auto-recover off, it is more trouble that it is worth and can slow thing right down as well. Just save the darn workbook whenever you need too. How hard is it add "ctrl+s" to your keystrokes when required? The vast majority of errors I audit and fix are due to ignorance and carelessness. You either seem to understand spreadsheet logic or you don't. Hmmmm... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson Sent: Thursday, 29 May 2014 5:29 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] [dba-OT] Why You Shouldn't Use Spreadsheets ForImportant Work Does spreadsheet data ever "degrade"? I suspect it does, and that auto recover can adversely affect things after Excel crashes. I would not use spreadsheets to house data, only logic and manipulation techniques. And I would audit the functionality regularly. Many users are not taught what can go wrong with them. It is not always user error, but ignorance. Bill -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com