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
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" <Wilbur.24i40n_...@excelforum-nospam.com> wrote in message news:Wilbur.24i40n_...@excelforum-nospam.com...
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