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