HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB)

[Bill Ridgeway]

It would be good to have a bit more information like-
what prompts you see a need to reduce the size of the file?
have you deleted all the data you don't want?--

Regards.

Bill Ridgeway
Computer Solutions

 

[Pete_UK]

If you have a lot of formulae in the workbook then you can reduce the
size by fixing these to values - Copy, Edit, Paste Special, Values etc.
Also, if you have a lot of named ranges which are no longer required,
these can increase the size of the file. In addition, you could check
on each worksheet what Excel thinks is the last used cell (CTRL-End),
as you may have a lot of excess rows or columns and these can be
deleted.

Hope this helps.

Pete

 

[venkateswaran]

It is big status report with 25 sheets in it, i cant delete any data.
The file size is around 4 mb
is there any way to reduce the size, without zipping, removing formats,
validations etc?

 

[Bill Ridgeway]

Pete UK has suggested how you could reduce the size of the file and I
appreciate that with 25 worksheets doing this would be a bit of a job.
However, you haven't said why you feel this needs to be done.

Regards.

Bill Ridgeway
Computer Solutions

 

[vandenberg p]

Hello:

Reminds of the person who asks can I lose weight? (and not reduce what I eat and without
excerising more) NO.

Pieter Vandenberg


: It is big status report with 25 sheets in it, i cant delete any data.
: The file size is around 4 mb
: is there any way to reduce the size, without zipping, removing formats,
: validations etc?

 

[Marc]

A slightly off the wall suggestion--make sure you are saving it as a "pure"
excel file type. By that I mean saving a file as "Microsoft Excel Workbook
(*.xls)".

If you save with a type like "Microsoft Excel 97-2002 & 5.0/95 Workbook
(*.xls)" you can easily double the file size.

I just opened up a 19MB file I have and did a "save as" to the combined file
type in the above sentence--it nearly doubled in size...

You can easily remove "excess" formatting with a "clear excess formats"
excel addin--I think I found in on the Microsoft support website--don't
remember...