Have a look at some of the optimizing methods at Charles Williams' site.

http://www.decisionmodels.com/


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 15:09:04 -0800, GautamJay
wrote:

Hi, I have developed the automated excel file for my team member production.
However, now i found that by the end of the week file become so heavy that it
take lot of time to save. Need help to sort out this problem