Really large Excel File size

Hi,

I have an excel sheet which also has a VBA user form, you can enter, date and it will input into certain rows and columns there are also a few forumlas in use.

However the file size is HUGE it's 7mb, it never used to be this large, but now suddenly it is very big and takes a while to open/save and it hard to share, any advice on where to start to reduce the size or fix the problem would be amazing>

I am using the following in the sheet.

• Conditional formatting
• VB
• User input form
• 3 sheets
• IF functions
• General calculations
• A few macros

Help much appreciated.

Mike

hi,

Save excel file in .xlsb format.

Saving it in a binary format only halves the file size to 4mb, i am looking at a file size that should be around 100-200kb MAX, no sheet should need to be bigger than this?

I am assuming it has something to do with the way the program is coded from Microsoft and the way the program saves certain types of formatting.

Manually, Go to last used cell from there hit Ctrl + End and see where its going .. If it's takes you to new UNUSED cell then from used cell to till that point hit DELETE.

I have done this and the last used cell is the cell that is my last used cell. It doesn't take me anywhere else.

I would upload an example but the file size it to big for here.

mike

Ok. Then review your conditional formatting and reduce unnecessary CF.
do you have any ranges which is formatted as TABLE ? Then make them as normal range.
If you have many formulas in Excel then you can pass those formula via VBA code into excel by restricting those formulas to only NON Empty Cells.