• 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


  • 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


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.


Excel Ninja
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.