| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
File size
Helps quite a bit actually. Cheers
Thanks "Gary''s Student" wrote: 1. If you have pivot tables, consider not saving them with the file. Clear the table and re-create them with macros after you have opened the file. 2. If you have the same equation/formula pasted down 10's of thousands of rows, consider not populating the column until after the file is opened and then doing the copy with a macro. -- Gary''s Student - gsnu200847 "LiAD" wrote: Hi, I have an excel folder which has four copy paste delete type macros working between about 10 sheets and several large databases of 2000 products and machines with index, match and calculation functions. The file is growing at a collosal rate, its now 84M! Is there any way of reducing this without having to start from scratch? Thanks LiAD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
| Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
| WHY IS MY FILE SO BIG? How can I reduce the size of a file? I h. | Excel Discussion (Misc queries) | |||
Threaded Mode
