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.



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

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

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

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
.