How can I check the file size of each worksheet in an Excel Doc
 

My Excel Spreadsheet has multiple tabs but the file size has increased
dramatically for no apparent reason.

Is there a way to check the file size of each individual tab (worksheet)
within the document so I can pin point exactly where the increase occurred?

How can I check the file size of each worksheet in an Excel Doc
 

Look in the vba help index for FILELEN

--
Don Guillett
SalesAid Software

"Chris1707" wrote in message
...
My Excel Spreadsheet has multiple tabs but the file size has increased
dramatically for no apparent reason.

Is there a way to check the file size of each individual tab (worksheet)
within the document so I can pin point exactly where the increase
occurred?

How can I check the file size of each worksheet in an Excel Doc
 

Just a simple fix when you find your bad sheet:

A common reason for dramatic increase in file size is extra rows/columns
included in the file. Look at your scrollbars compared to your data. If
there's a lot of scroll left at the rightmost and bottommost cells, highlght
the extra rows/columns, delete, move to cell A1 and save. This will
automatically reduce the size.


"Chris1707" wrote:

My Excel Spreadsheet has multiple tabs but the file size has increased
dramatically for no apparent reason.

Is there a way to check the file size of each individual tab (worksheet)
within the document so I can pin point exactly where the increase occurred?