Excel 2010 and 2007 saving in 2003 Format

**yawnzzzz** · 08-10-2011, 11:00 PM

I have a workbook that's developed on 32-bit Windows XP using Excel 2007 and saved in 97-2003 format (xls aka FileFormat = 56). When I do this, the file's around 3.6 MB. I now went to a computer that's running 64-bit Windows 7 using Excel 2010 and saved it in 97-2003 format again, and it dropped to 2.3 MB.

I'd love to jump for joy that Excel 2010 improved the efficiencies in compatibility mode, but I'm just as fearful that there's a bug. Has anyone experienced this?

**teylyn** · 08-10-2011, 11:23 PM

Hello,

An xls file is always bigger than the same file saved as an xlsx, be it 2007 or 2010. Microsoft changed the file format with Office 2007. The new file formats are like ZIP files. You can even rename an XLSX with a ZIP extension and then extract the individual files.

cheers,

**yawnzzzz** · 08-10-2011, 11:35 PM

Originally Posted by teylyn

Hello,

An xls file is always bigger than the same file saved as an xlsx, be it 2007 or 2010. Microsoft changed the file format with Office 2007. The new file formats are like ZIP files. You can even rename an XLSX with a ZIP extension and then extract the individual files.

cheers,

Hi, thanks for the reply. I'm familiar with xlsx. What I'm referring to is saving in xls format using 2007 versus saving in xls format using 2010.