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.com


"gennario" wrote in message
...
I know how to tell the size of excell document but is there a
way to tell the
size of each tab?

yes - I do mean the memory. I was wondering which tab is eating up all the
memory---too bad!!

"Chip Pearson" wrote:

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.com


"gennario" wrote in message
...
I know how to tell the size of excell document but is there a
way to tell the
size of each tab?

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:

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

--

Dave Peterson

Thanks Dave - that helped and I was able to find my "big eater" & now I will
deal with it!

really appreciate!!!!

"Dave Peterson" wrote:

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:

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

--

Dave Peterson