Jim Lawrence
accessd at shaw.ca
Wed Aug 22 13:11:32 CDT 2007
John; this is the time you call in Susan. A perfect book for all those with computer jobs, working at home with kids... Jim -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, August 22, 2007 10:49 AM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Excel overflow error >JC, you just wrote a children's book -- you realize that right???? ;) Just the ticket for my intended audience, right? ;-) John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Wednesday, August 22, 2007 1:35 PM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Excel overflow error Arthur... It means that an expression is stuck or cycling without an anchor to stop it. ;) Dividing by 0 produces an "overflow" in Access -- same thing really. JC, you just wrote a children's book -- you realize that right???? ;) Susan H. This generally occurs when water behind a dam reaches the top and starts to "over flow" or flow over the top of the dam. Now, applying this metaphor to Excel, I would guess that the spreadsheet is becoming full of numbers and are starting to "over flow" or flow over the top of the spreadsheet. I had this happen one time and I ended up with numbers all over the floor. To make matters worse, I was inserting numbers into the spreadsheet with a program that had pulled a recordset with millions of records so I was trying to mop up the numbers at the same time I was frantically searching for how to stop the program from running. It was a MESS!!! I had numbers spilling down the stairs, my kids were running around downstairs collecting them in cups and pouring them all over each other. We were cleaning up numbers for weeks - under the beds, in the bath tub, even number handprints on the fridge. Take my word for it, get this thing fixed QUICKLY or you could have a disaster on your hands. Is it Friday yet? ;-) John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Wednesday, August 22, 2007 12:57 PM To: Discussion of Hardware and Software issues Subject: [dba-Tech] Excel overflow error Can someone advise what is occurring when I get an error message from Excel that says "Overflow." That's all it says. TIA, Arthur _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.1/963 - Release Date: 8/20/2007 5:44 PM _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com