Reducing a file size

myroz

New Member
Joined
Nov 17, 2008
Messages
39
Excel 2007<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
This is probably really simple. i have a large file and its performance is being compromised by its size, would it help if i reduced / removed the empty rows and columns.<o:p></o:p>

Thanks in advance
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,751
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
How big is it ?
If it has lots of Pivot tables, Graphs, Images, etc...there's not a lot you can really do.

Reducing / removing rows and columns will do nothing, if those rows and columns are genuinely empty.
 

myroz

New Member
Joined
Nov 17, 2008
Messages
39
its 70 MB, a colleague claims that i can reduce it by 30 MBs by ...

"...
Just been playing around with the speadsheet. If you delete all the unused rows in the four tabs (from about row 5900 onwards), you'll be able to shave off about 40mb from the file size (mine went from 71mb to 32mb)). Might make life a bit easier!..."

Im loathed to ask him......
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,751
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Have you tried pressing CTRL + End and see where the cursor finishes ?
Do the same with CTRL + Right Arrow
If these cell locations are a long way past the end of your actual data then delete the rows and columns to those points.
Save the worksheet and reopen it, the CTRL + End should now be at the last point in your data.
This may save a lot of file size !!
 

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,364

ADVERTISEMENT

a lot of things can increase the file size.
what file format is it? (xls or XLSX/XLSM - meaning not the version of Excel you use but the file type itself)
is it full of graphs, images, buttons and code, digital signatures, formulas ...
if you provide a link to the file it will probably be easier.
on what machine do you use this "monster"? :)
 

myroz

New Member
Joined
Nov 17, 2008
Messages
39
its and xlsx but it only contains figures and formulas with a few lookups. but it covers masses of individual data which is important to view input and output.
 

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,364
well i think it will be best to share the file for checking (if it isn't confidential or too secret).
try to check Michael M 's suggestion(post #4), try also if there are some hidden sheets or anything like this, digital signatures or passwords, etc.
how many sheets & what is the average amount of cells filled per sheet?
 

myroz

New Member
Joined
Nov 17, 2008
Messages
39
unfotunately its my (well the one i work for) companies 5 year forecasting model. i have some ideas on how to speed it up on the whold by modulerising it. did i just make that word up. thanks for your help.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,719
Messages
5,597,734
Members
414,170
Latest member
Mdm

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