Do you have any suggestions on making Excel files more compact? I have one that is pushing 10MB and it takes a long time to save because of the data contained within it. I update it each day with new data. Thanks in advance!
Personally, I keep my workbooks very small and therefore usable. However, not knowing the details of your particular situation, I can't really advise you on exactly what to do. Unless you need ALL of your data ALL of the time there is no good reason to use the same workbook for data entry and storage. Provide more details or zip and mail your workbook with an explanation.