size of tabs

G

gennario

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

Chip Pearson

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
 
G

gennario

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

Dave Peterson

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

gennario

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

really appreciate!!!!
 
Top