View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jclemen1 jclemen1 is offline
external usenet poster
 
Posts: 1
Default How reduce the file size of Excel 2007 files (wasted non value spa

In Excel 2003 after running VBA programs many times there was extra
data/garbage in rows that follow the primary data (but not viewable). I
would delete the data and immedately save the file and the size would be
greatly decreased. In 2007 I am working with more records but I cannot
reduce the files size through deletion of unused rows. The slider bar
indicator is small and moves down the row less than a quarter of the way when
I hit the end of my data.