Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Workbook got too large

5 views
Skip to first unread message

Wilbur

unread,
Mar 11, 2006, 10:37:46 AM3/11/06
to

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?action=getinfo&userid=31826
View this thread: http://www.excelforum.com/showthread.php?threadid=521343

EvolBob

unread,
Mar 11, 2006, 11:21:15 AM3/11/06
to
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

robe...@orcon.net.nz

"Wilbur" <Wilbur.24i40n_...@excelforum-nospam.com> wrote in message news:Wilbur.24i40n_...@excelforum-nospam.com...

GS

unread,
Mar 12, 2006, 12:10:26 AM3/12/06
to
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

0 new messages