Making Excel Files More Compact

friendlyfan

New Member
Joined
Nov 26, 2005
Messages
5
Do you have any suggestions on making Excel files more compact? I have one that is pushing 10MB and it takes a long time to save because of the data contained within it. I update it each day with new data. Thanks in advance! :)
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Personally, I keep my workbooks very small and therefore usable. However, not knowing the details of your particular situation, I can't really advise you on exactly what to do. Unless you need ALL of your data ALL of the time there is no good reason to use the same workbook for data entry and storage. Provide more details or zip and mail your workbook with an explanation.

Tom
 
Upvote 0
Over time, you may find you can either

a] atchive some of your data, or

b] convert some [older/not-to-change-again] formula-driven cells to their values, or

c] convert formulas to macro routines.
 
Upvote 0
OP: If you could post back about the features of your file, that would really help us to diagnose it better.

For example,

1. If there a lot of drawings, pictures or images in the file, that would explain it.

2. If you have pivot tables in the file, that could be another culprit.

3. If you have deleted data by selecting the rows and merely pressing the delete key, that would explain another issue.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,142
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top