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