I have a problem in that i perform lots of analysis using formula. In an attempt to speed the sheet up i have copied these formula to a control sheet from which i re put them into my master sheet and then replace as values. The problem is that this workbook is rather huge and has become very slow rather quickly.
Example formula are ;listed below. I was wondering what would be the most robust method of performing this analysis. Via macro? or a different way of writing my formula?
Any comments,/help/examples would be appreciated.