1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to find what formula uses more memory in excel

Discussion in 'Ask an Excel Question' started by Anbuselvam K, Jan 10, 2019.

  1. Anbuselvam K

    Anbuselvam K Member

    Messages:
    136
    Hi

    I have Excel workbook with a memory of 8MB which is having normal formulation, array formulation and macro codes. I saved the same file in binary format then it is reduced to 5MB.

    I want to determine which formula is taking more memory or what are all taking memories in the sheet.

    Can anyone please suggest the way to find the same?

    Thanks in advance.
  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,692
    I don't think think Formulas take up much space and they are easily compressed
    What generally stops file being shrunk is embedded pictures and other objects (Controls etc). Pivot Caches also take up room.

    Have a read of: https://trumpexcel.com/reduce-excel-file-size/
  3. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,171
    Another thing to keep in mind is all the custom formats etc.

    Excel uses Office Open XML file format to store info. Each distinct format type will be stored as it's own xml node and will take up more memory than shared format.
  4. Anbuselvam K

    Anbuselvam K Member

    Messages:
    136
    Thanks for your valuable reply.

Share This Page