May 26 2018 04:49 PM
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
May 26 2018 10:58 PM
May 27 2018 02:34 AM
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
May 27 2018 03:13 AM
May 27 2018 04:00 AM
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
May 27 2018 04:24 AM
SolutionClick 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
May 27 2018 04:29 AM
Mr. Wyn Hopkins
The size is now 63 KB !!!!
whew..
MANY MANY THANKS
May 27 2018 04:24 AM
SolutionClick 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