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