software

I know how to tell the size of excell document but is there a way to tell the
size of each tab?

Do you mean the memory used by each tab? If so, the answer is no.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;gennarioquot; gt; wrote in message
...
gt;I know how to tell the size of excell document but is there a
gt;way to tell the
gt; size of each tab?
yes - I do mean the memory. I was wondering which tab is eating up all the
memory---too bad!!

quot;Chip Pearsonquot; wrote:

gt; Do you mean the memory used by each tab? If so, the answer is no.
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;gennarioquot; gt; wrote in message
gt; ...
gt; gt;I know how to tell the size of excell document but is there a
gt; gt;way to tell the
gt; gt; size of each tab?
gt;
gt;
gt;

copy each worksheet to a new workbook (single sheet only). Save each workbook.

You could get a gross estimate of which was the big eater by looking at the file
size.

gennario wrote:
gt;
gt; I know how to tell the size of excell document but is there a way to tell the
gt; size of each tab?

--

Dave Peterson

Thanks Dave - that helped and I was able to find my quot;big eaterquot; amp; now I will
deal with it!

really appreciate!!!!

quot;Dave Petersonquot; wrote:

gt; copy each worksheet to a new workbook (single sheet only). Save each workbook.
gt;
gt; You could get a gross estimate of which was the big eater by looking at the file
gt; size.
gt;
gt; gennario wrote:
gt; gt;
gt; gt; I know how to tell the size of excell document but is there a way to tell the
gt; gt; size of each tab?
gt;
gt; --
gt;
gt; Dave Peterson
gt;