SOLVED

workbook file size seems too big

Bronze Contributor

I have a workbook with only one worksheet, in that worksheet - 4 columns with drop down control buttons up to 140 rows and 4 columns of drop down list with data up to 300 rows and the file size is 11.8 MB !

there is no pictures/images of any kind in the workbook, just 2 modules of vba control codes.

I wonder if this can be reduced somehow, it takes about 12 seconds to open the workbook, I am worried if more data is added...

many thanks

 

6 Replies
Hi Lorenzo,

Any hidden sheets?

When you press End Home what cell does the cursor jump to?

If it's way down in the bottom right corner you can try deleting all the empty rows and columns and then save your file.

Mr Wyn Hopkins

 

Thank you for your reply.

My workbook do not have hidden sheets.

when I press Ctrl End - it went to the bottom at P1048576.

How do I delete all the empty rows?

THANK YOU

From that bottom cell hold down Ctrl & Shift then press the Up arrow key.

This will highlight all the rows

Then go to
Home > Delete.. Entire Sheet Roe

Mr Wyn Hopkins

Thank you for your reply.

My workbook is a monthly record of items returned by clients for whatever reason (status) and the actions taken. This will in turn be used for analysis to find ways to minimize damages.

Attached are images of my workbook.

For data entry - rows up to 1001

Columns C,D,G,H have drop down buttons for users to select data (all 1001 rows)

the drop down lists is from Q to U column and can go more than 1001 rows

how do I delete those unneeded rows/columns to lessen the file size?

the last column used is U

 

MANY MANY THANKS

 

RAD Form - data entry.PNGRAD Form - drop down list.PNG

 

 

 

best response confirmed by Lorenzo Kim (Bronze Contributor)
Solution

Click on U1002  then hold Ctrl + Shift and press the down arrow key to highligh all the empty rows

Then go to Home > Delete > Delete Sheet Rows.

Close and Save your file

 

image.png

Mr. Wyn Hopkins

The size is now 63 KB !!!!

whew..

MANY MANY THANKS

1 best response

Accepted Solutions
best response confirmed by Lorenzo Kim (Bronze Contributor)
Solution

Click on U1002  then hold Ctrl + Shift and press the down arrow key to highligh all the empty rows

Then go to Home > Delete > Delete Sheet Rows.

Close and Save your file

 

image.png

View solution in original post