Closed Thread
Results 1 to 5 of 5

Macro file has become too heavy

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Macro file has become too heavy

    Ive been learning macros for almost 4 months and have created more than 300 macros, but the problem is whenever i create any macro file the excel file becomes very heavy, even though there is hardly any data in that. With that much amount of data a normal file would be 250kb but where as a macro file with that much data with addition to a couple of macros will be 7Mb, y is that?? is that common or am i the only one facing this problem??
    This has happenned to me in more than 20 files, please help :D

  2. #2
    Forum Contributor
    Join Date
    05-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Macro file has become too heavy

    hi suraj,

    try deleting empty cells in entire workbook

  3. #3
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro file has become too heavy

    Duplicate post

    http://www.excelforum.com/excel-prog...ery-heavy.html

  4. #4
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Macro file has become too heavy

    Thank You very much it worked perfectly, it came down for 11MB to 72Kb !!!! But do i have to do this to all the files i create ?? y does it happen like this?? so that i can avoid from having to do this next time..

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,196

    Re: Macro file has become too heavy

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. File has become very heavy
    By Suraj3825 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 02:49 PM
  2. [SOLVED] Macro/VBA to Outline Multiple Shaded Cells with Heavy Borders
    By cmaunder in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2013, 07:08 AM
  3. How to reduct heavy data of excel file.
    By Shermaine2010 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2011, 04:34 AM
  4. File size became Heavy
    By abhijit786 in forum Excel General
    Replies: 1
    Last Post: 01-02-2011, 07:46 AM
  5. Lookup from a very heavy file
    By Hari in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-23-2006, 02:35 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1