J.Ty.
Well-known Member
- Joined
- Feb 4, 2012
- Messages
- 1,118
- Office Version
- 365
- 2013
- 2010
- Platform
- Windows
- Web
Hi,
Is there a way to estimate the memory consumption of an Excel spreadsheet?
To be precise, I have a spreadsheet. Its main worksheet contains 30 columns of quite complex formulas. I want to fill it down "as far as it goes", but without exceeding the available RAM.
So what I need is a method to estimate how the number of rows with those formulas relates to the amount of necessary memory. I imagine that I create, say, 10000 rows and see how much space they neeed, and then calculate the maximal number of rows I can afford on my machine.
Best regards,
J.Ty.
Is there a way to estimate the memory consumption of an Excel spreadsheet?
To be precise, I have a spreadsheet. Its main worksheet contains 30 columns of quite complex formulas. I want to fill it down "as far as it goes", but without exceeding the available RAM.
So what I need is a method to estimate how the number of rows with those formulas relates to the amount of necessary memory. I imagine that I create, say, 10000 rows and see how much space they neeed, and then calculate the maximal number of rows I can afford on my machine.
Best regards,
J.Ty.
