ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   size of tabs (https://www.excelbanter.com/excel-discussion-misc-queries/73347-size-tabs.html)

gennario

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

Chip Pearson

size of tabs
 
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?




gennario

size of tabs
 
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?





Dave Peterson

size of tabs
 
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

gennario

size of tabs
 
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



All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com