Memory usage very high

Posted by: jameshoughton on 8 September 2017, 12:56 pm EST

  • Posted 8 September 2017, 12:56 pm EST

    HI,


    We have a workbook consisting of about 10 sheets.  3 of these sheets each contain about 50,000 rows (it's all the same data just ordered differently between them). They have about 40 columns each.


    The other sheets contain summaries on this data and only contain between 3 and 10 columns.


    When running the app seems to consume about 1GB (GIGABYTE) of RAM.


    We are using 3.0.2003.2005.


    Any thoughts if this sounds right?!


    Thanks.


    James.

  • Replied 8 September 2017, 12:56 pm EST

    James,


    If I counted correctly, this is about 8,000,000 cells of data. If there is also formatting on a lot of cells, then this memory allocation sounds like it could be correct.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels