I suggest you look at my web pages on optimising calculation speed.
http://www.DecisionModels.com/optspeedd.htm etc


Charles Williams
Decision Models


Can anyone provide me with some other tips which I can use to reduce the
size and increase the speed of this spreadsheet. Or tips that I can used
to
identify what portion of the spreadsheet contributes to size and speed
loss.