File size problem ???
 

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

File size problem ???
 

Hi Michael,

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

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


---
Regards,
Norman


"Michael Beckinsale" wrote in message
...
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

File size problem ???
 

Norman,

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

Michael

"Norman Jones" wrote in message
...
Hi Michael,

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

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


---
Regards,
Norman


"Michael Beckinsale" wrote in message
...
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