+ Reply to Thread
Results 1 to 3 of 3

Heavy table with no macro

  1. #1
    Registered User
    Join Date
    06-29-2016
    Location
    london
    MS-Off Ver
    2016
    Posts
    1

    Heavy table with no macro

    I have been trying to develop a budget template in an excel doc. The template is using formulas referring only to other cells or TAB within the one doc so I don’t understand why it is so heavy 19MB while there is no Macro. Any idea why and how to reduce the file size?
    Thanks,

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Heavy table with no macro

    As far as I can tell the problem sheet is MB Detail, after that sheet is deleted and the workbook saved the file size drops to 1.78MB.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    12-22-2015
    Location
    Huntsville, AL
    MS-Off Ver
    2007
    Posts
    92

    Re: Heavy table with no macro

    Yeah, I agree it's the MB Detail sheet. You have a bunch of filled in cells with formulas that are working despite there being no data with which to work? That seems a bit unnecessary. Why not find a way to use the Excel Table feature that way you don't need all those cells filled in ahead of time? When you add a row for new data, the columns with the formula will automatically fill down.

    Just a thought.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 04-30-2014, 02:56 PM
  2. [SOLVED] Macro for various customised Report of complex heavy Data file
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2014, 09:57 AM
  3. [SOLVED] Too heavy and slow.
    By heuder in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2014, 09:29 AM
  4. Macro file has become too heavy
    By Suraj3825 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 03:16 PM
  5. File has become very heavy
    By Suraj3825 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 02:49 PM
  6. [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
  7. Heavy Excel Sheet
    By pansovic in forum Excel General
    Replies: 2
    Last Post: 06-18-2010, 12:52 PM

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