compact excel 2003

  • Thread starter Thread starter F_O_A_K
  • Start date Start date
F

F_O_A_K

I have a spreadsheet in Escel 2003 with some VBA code to do multiple
conditional formatting (i.e. more than 3 conditions). Is there a way of
compacting the file so that it saves quicker?
 
Formulas and conditional formating will increase the size of a workbook
signifcantly and wil increase the time to save since larger files take longer
to save. If you don't need to update the workbooks on-the-fly (as people
make changes) and can manually run macros to perform the same functionality
then the macros will reduce the time to save the file. You can replace
conditional formating with macros that can perform the same highlighting and
error checking. The macro(s) will be run after all the data has been entered.
 
Back
Top