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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a steep learning curve for excel 2008 VBA as opposed to2003? 3
Custom face for custom toolbar item 2
Macro to search for a file and return it's full path 1
User-defined function to give blank cell? 1
recognizing conditional formatting with VBA 3
Lose macros before saving 4
Count Conditional Formatting Colours - Excel 2003 4
Help with sorting data 3

Back
Top