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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
L

Legacy 98055

Guest
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
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
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.
 

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,113
Messages
5,835,456
Members
430,357
Latest member
Greshapa

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
Top