File size problem ???

[Michael Beckinsale]

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)),"Contractor",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

 

[Norman Jones]

Hi Michael,

See Debra Dalgleish's suggestions for resetting the Used range:

http://www.contextures.com/xlfaqApp.html#Unused

 

[Michael Beckinsale]

Norman,

Many thanks. I will give it a try a see if the file size reduces.

Michael