Other than saving a blank workbook as a template and naming it
Book.XLT then you may want to check with the Excel newsgroup and see
if anyone knows more.
Also note there is a maximum number of formats that can be saved in a
workbook. If you really have a 'zillion' formats then you can begin to
encounter other problems.
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~
Beth Melton
Word FAQ:
http://mvps.org/word
TechTrax eZine:
http://mousetrax.com/techtrax/
MVP FAQ site:
http://mvps.org/
Help! I've defined a zillion custom colors for the worksheet fills
and lines for Excel 2000. And I can't figure out how to make it the
default!