View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy Payne Andy Payne is offline
external usenet poster
 
Posts: 1
Default Excel 2007 export file size huge

When exporting from Quick Books to Excel the new 2007 version generates file
sizes of 2+MB for the same reports and data the would produce file size of
about 50KB in previous versions of Excel. It seems that regardless of
content exported Excel 2007 creates 65,000 lines for each worksheet.

Is there a selection in Excel 2007 that would prevent this excess space
being created?
--
Andy