Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Wed May 16 15:37:07 CDT 2007
Sounds like a job for a piece of code behind the spreadsheet. Rocky -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jon Tydda Sent: Wednesday, May 16, 2007 1:23 PM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Excel bloat question You have to copy everything from the spreadsheet into a new one, relink everything, copy all the vba across and save it... voila, you get a new document with the same features as the other one, but around half the size. Jon -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: 16 May 2007 21:16 To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Excel bloat question XL bloats? Who knew? How do you unbloat? (the sheet, that is; not you) Rocky -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Wednesday, May 16, 2007 1:04 PM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Excel bloat question Wow -- I had no idea -- thanks Jon! I wanted to write about bloat on an Office blog, but didn't know if it really mattered. Susan H. Yes, totally. We've got some spreadsheets at work that just keep track of courier requests etc, and they have lines added, removed, and coloured maybe 10 times a day. After a year or so, they get to a big enough size that some of the lower end PCs just can't open them, and that's only around the 5-6mb mark. _______________________________________________ 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.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com -- This email has been verified as Virus free Virus Protection and more available at http://www.plus.net _______________________________________________ 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.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM