7+ MB with 16 sheets is a bit large for a Template Will.
How is the user opening the file?

If this is a genuine template file with an xlt extension, you may be better off to make some sheet templates and just use these as required.
Otherwise trim the differring formats like merged cells, have just one type of font and borders.
Loose any shapes or drawing objects.
You could send me the file - but I can't promise much if you don't like major surgery - which I expect this will need.

I'm assuming you've tried to loop through the workbook to copy just the data & formulae to new sheets?


Regards
Robert McCurdy



"Wilbur" wrote in message ...

I am creating a template with VBA code to run it. I also use cell names.
I started out with 16 sheets and saved it and it was 53K. I added the
formatting and named 6 columns that are used for totals and when I
saved it the size was now 7,345K. I deleted all the names and it never
got smaller. Is there a way to clean it up?

Thanks…


--
Wilbur
------------------------------------------------------------------------
Wilbur's Profile: http://www.excelforum.com/member.php...o&userid=31826
View this thread: http://www.excelforum.com/showthread...hreadid=521343