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
.