reduce the size of a file
Hi Jason -
I have a similiar issue with a 'template' that I use each week. It's
not really a template, but a 'read-only' version of a workbook
containing lots of sheets, formulas, links, etc.
My solution was to create a macro that valued out (ie Copy-PasteValues)
all of the formulas before saving the finished product with a unique
name (adding the date to the end). Doing this saved about 1/3 of the
file size.
Maybe you could try this (on a copy of the file, of course) ... and if
it seems to do what you want, I can give more details on how I did it.
//ray
Jason M wrote:
Are there things that I can do to reduce the size of my excel file?
Currently, my file is slightly over 3 mb and contains over 25 sheets. I
streamlined my formulas, eliminated duplicate references, removed graphics,
etc in an effort to get the file size down. Users with older, slower PCs are
getting delays when opening the file. Any help would be greatly appreciated!!
Jason
|