I know how to tell the size of excell document but is there a way to tell the size of each tab?
G gennario Feb 23, 2006 #1 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 Feb 23, 2006 #2 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
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 Feb 23, 2006 #3 yes - I do mean the memory. I was wondering which tab is eating up all the memory---too bad!!
D Dave Peterson Feb 23, 2006 #4 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.
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 Feb 23, 2006 #5 Thanks Dave - that helped and I was able to find my "big eater" & now I will deal with it! really appreciate!!!!
Thanks Dave - that helped and I was able to find my "big eater" & now I will deal with it! really appreciate!!!!