Excel file big for no apparent reason

ThomasHOL

New Member
Joined
Oct 15, 2014
Messages
31
I have a problem that one of my excel files have gotten unusually big and because fo thei also very slow.

I have identified the reason and it seems that 6 different sheets suddenly take up much more space than needed maybe because we are converting it from XLS format to XLSM as a part of coding new macros. The sheet is the primary way of managing the economy of our construction process and has been build up over the last 20 years and contains about 3000 lines of macro code and hundreds of named fields etc. So starting over is not really an option in the short run.

But as I said I have identified the offending sheet and I deleted all the other sheets in the workbook. I then deleted all the macros and finally i had a workbook that is about 2.6 mb in size. I then delete all the data in evet possible way i can think of. I simply select the entire sheet and delete all the data. I also tried the option to clear data and selected all. I checked that there is no conditional formatting or links to other files. All looks empty but the file is still 2.6 mb large

The only thing I can see is that if I do a CTRL+END I end up in the last row of the sheet but there is no way i can change this.

I have uploaded the file on my dropbox and you can find it here BigFileNoReason.xlsm

I hope you have any good suggestions.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,453
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Select all the cells, then set the Rowheight to 15, then save the file.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,321
Messages
5,624,012
Members
416,005
Latest member
judi slot terbaik

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