Estimating memory usage per worksheet
 

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

Estimating memory usage per worksheet
 

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.



Simon wrote:

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

--

Dave Peterson

Estimating memory usage per worksheet
 

And this doesn't really estimate memory usage -- just how much space it would
take on disk.

Dave Peterson wrote:

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.

Simon wrote:

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

--

Dave Peterson

--

Dave Peterson

Estimating memory usage per worksheet
 

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.

--
Cheers
macropod
[Microsoft MVP - Word]


"Simon" wrote in message ...
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

Estimating memory usage per worksheet
 

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" wrote:

And this doesn't really estimate memory usage -- just how much space it would
take on disk.

Dave Peterson wrote:

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.

Simon wrote:

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

--

Dave Peterson

--

Dave Peterson
.