Size of workbook is over 5MB - How to reduce?

[Jeffrey Sheldon]

We have a workbook that contains three worksheets.
Worksheet one is designed as an input form for budget
additions. Worksheet #2 and #3 are the values that
create a tab delimited file to load into our Financial
package.

All three worksheets are no large than 60 rows and do not
go past BA column. These are fairly small sheets.

However when I go to save it, saving takes forever and
the size of the file is 5mb.

It appears that the 'end of file' is the max in both ways
(column and row). How can I reduce the file size?

Thanks

 

[Norman Harker]

Hi Jeffrey!

You need to re-set the used range. Take a look at the suggestions for
both manual and code approaches at:

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

You might also find some useful tips at:

Charles Williams
http://www.decisionmodels.com/optspeedd.htm#Size
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.