Estimating memory usage per worksheet

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Is it possible to get an estimate of the file size of a spreadsheet by
individual worksheet?

I cannot think of a worksheet property that would contain this, so I assume
that one needs to count sheet elements and apply a per-object memory value
(this only needs to be an estimate) to get the estimat.

Any help would, as always, be much appreciated

Thanks in advance


Simon
 
I'd try this.

Start a new workbook -- with just a single sheet.
Save this workbook. Note the size (using windows explorer).

Then against a copy of the real workbook (just in case you mess up), copy each
worksheet you're interested in to a new workbook.

Save that new workbook with the single sheet. Note the size of this workbook.

Repeat as required.

You'll see that excel has a "get started" cost with that single empty sheet
workbook. But you'll be able to compare the relative sizes of the other single
sheet workbooks to get a general idea.
 
And this doesn't really estimate memory usage -- just how much space it would
take on disk.
 
Hi Simon,

You could use:
=INFO("memused")
in an otherwise empty wb before loading the wb you want to test, then:
1. open the wb you want to test;
2. update the calculation; and
3. calculate the difference.
 
Thanks Dave,actually I really meant filesize rather than memory usage as such
so this approach is fine. The spreasheet in question has about 30 tabs, which
makes the manual approach a little time consuming, but you have given me an
idea- I will report back (hopefully!)

Simon

Dave Peterson said:
And this doesn't really estimate memory usage -- just how much space it would
take on disk.
Click to expand...
 
Back
Top