Hi All,

I have a workbook which is in effect used as a template and the file size is
805KB.

Before sending it to the user data was added into a single worksheet by
copy/paste special values. The range covered was B2:AM312. Additionally the
following formula was inserted into the range X2:X312

=IF(ISERROR(LOOKUP(K2,Grades,Position)),"Contracto r",LOOKUP(K2,Grades,Position))

where Grades is another sheet range A2:A155
where Position is another sheet range C2:C155

Then on File Save As 'new file name' the file escalated in size to 5444 KB
which seems extraordinarily large.

Does anybody know how l can find out what is causing this and how to rectify
it ?

Is it anything to do with the way Excel records the LastCell ?

All help gratefully received.

Regards

Michael Beckinsale