Results 1 to 2 of 2

why the file size is so large without any reason?

This is a discussion on why the file size is so large without any reason? within the Excel Questions forums, part of the Question Forums category; I created two user forms in a new workbook. Althought i havent put any data in the workbook, it is ...

  1. #1
    Board Regular
    Join Date
    Apr 2003
    Posts
    74

    Default why the file size is so large without any reason?

    I created two user forms in a new workbook. Althought i havent put any data in the workbook, it is now 2.78mb. I am very confused about this. Will userform and VBA code cost a lot of space? Please help. I would really appreciate.

  2. #2
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,115

    Default Re: why the file size is so large without any reason?

    For some reason, VBA code can inflate file sizes quite dramatically. Excel doesn't reclaim wasted space when you edit code. One solution is to compile the entire project, export all code modules and forms, delete them from the workbook, save, close, open, re-import all modules and code, save.
    Messy but it often reduces the size...

    Denis

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com