Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Harrow, UK
    Posts
    53

    Unanswered: Is it possible to compact an Excel Template?

    Got a template that's a big big - 24Mb.

    Takes a while to load, so would like to compress / compact it.

    Can it be done?

    (I don't mean zip it, I mean just make it permanently smaller).

    thanks.
    Thank you,
    James

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. That depends. Often when saving XL creates additional temp files that still attach to the .xls file. I use FastExcel from DecisionModels and use the "Clean Workbook" routine. That gets rid of all temp files, unused styles, number formats, etc.

    Alternatively, do you have many formulas in the workbook? Are they efficient formulas, or resource hogs?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •