Blank Workbook has 248,037KB....

gwyzor

New Member
Joined
Jan 29, 2010
Messages
17
I just finished up a workbook with 28 sheets. There are 4 userforms, 2 of which are called by 12 of the sheets, and the other 2 by 1 sheet. In addition there is code added on 12 sheets to sort, copy and paste to other sheets.
There is a fair amount of code, but not any more than similar workbooks I have currently. Difference is, with no data entered, the workbook shows 248,037KB. Takes 8 minutes + to open, if it will open. Then several minutes to save or close.
Similar workbooks weigh in less than 1mb.
Any ideas what to look for with this workbook that would bulk it up so much???
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,919
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
First up, go to each sheet and do a CTRL + End.
See where the active cell is !
If its WaaY past the last row or column, try this.
Highlight the row after the last used row and then press CTRL + Down Arrow then delete ALL rows
Do the same with columns then Ctrl + Right Arrow Delete all the columns
When finished save and reopen.
Another thing to look at....are you unloading your userforms after they have been used, rather than hiding them ?? This will also make a difference
So, instead of
Code:
Userform. Hide
USE
Code:
Unload.Me
 

Forum statistics

Threads
1,141,728
Messages
5,708,134
Members
421,548
Latest member
douae

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