[dba-Tech] Excel bloat question

Jon Tydda jon at tydda.plus.com
Wed May 16 15:52:46 CDT 2007


I read somewhere that it saves all the "undo" information in the workbook,
and I'm not sure there's a way to get rid of it without starting over in a
new wb.


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:37
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] Excel bloat question

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
 

_______________________________________________
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




More information about the dba-Tech mailing list