Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compact excel 2003
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compact excel 2003
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. "F_O_A_K" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compact or Shrink down excel file | Excel Discussion (Misc queries) | |||
compact Access DB from Excel | Excel Programming | |||
HOW TO COMPACT AN EXCEL FILE | Excel Discussion (Misc queries) | |||
Compact Excel Spreadsheet | Excel Programming | |||
How to compact an Excel file with VBA | Excel Programming |