Workbook got too large

[Wilbur]

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…

[EvolBob]

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

[email protected]

"Wilbur" <[email protected]> wrote in =
message news:[email protected]...
>=20
> 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?
>=20
> Thanks=85
>=20
>=20
> --=20
> Wilbur
> =
------------------------------------------------------------------------
> Wilbur's Profile: =
http://www.excelforum.com/member.php...userid=3D31826
> View this thread: =
http://www.excelforum.com/showthread...eadid=3D521343
>

[GS]

Hi Wilbur,

I have a similar project with a templates workbook consisting of 17 product
sheets, and 2 hidden maintenance sheets (query lists). Each template has 2
picture objects, tons of Conditional Formatting and Data Validation cells,
and a very long list of local defined names. There's no controls on any
sheets because everything is handled by built-in functions or their
associated add-in. There's also no VBA components (userforms, modules). The
file size is 797kb. I don't think that's a "clean" size because I've been
modifying it like crazy lately and haven't done any housekeeping yet.

You might want to think about rebuilding it, but that would mean some major
surgery like Robert indicated.

One thing I've noticed about Excel files behavior is, you can open a file in
another version, do nothing, and after you save it, it shrinks in size.<??> I
think maybe the file is what some term as "corrupt", and probably should be
rebuilt from scratch if it can't be sorted out. <IMO>

HTH
Good luck!
GS