N Newbie Feb 11, 2004 #1 Is there a way to compact a spreadsheet that seems to have grown out of all proportion since I have added code. Like in Access? Thanks
Is there a way to compact a spreadsheet that seems to have grown out of all proportion since I have added code. Like in Access? Thanks
R Ron de Bruin Feb 11, 2004 #2 Hi Newbie Don't save the file in two versions but only as Microsoft excel workbook Not as 97-2002 & 5.0/95 workbook(this make your workbook big) You can use Rob Bovey's Code cleaner to clean up your code http://www.appspro.com/utilities/utilities.asp See Debra's site for cheking your Usedrange http://www.contextures.com/xlfaqApp.html#Unused
Hi Newbie Don't save the file in two versions but only as Microsoft excel workbook Not as 97-2002 & 5.0/95 workbook(this make your workbook big) You can use Rob Bovey's Code cleaner to clean up your code http://www.appspro.com/utilities/utilities.asp See Debra's site for cheking your Usedrange http://www.contextures.com/xlfaqApp.html#Unused
