View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default HOW DO FIND OUT THE SIZE OF EACH WORKSHEET WITHIN A WORKBOOK

You could copy each worksheet to a new workbook (each one to a separate
workbook), save those workbooks, then use windows explorer to look at the size
of those new workbooks.



keyson2004 wrote:

I have a very large wotkbook 10MB and want to find out how I can reduce it
and also find out the size of each worksheet within the workbook to see if
there is anything I can do to reduce the size of each worksheet. I use many
vlookup , if formauls in the workbook


--

Dave Peterson