Article ID: 293828 - View products that this article applies to.
This article was previously published under Q293828
When you update a Microsoft Excel spreadsheet through an ActiveX Data Objects (ADO) Recordset, the Excel file size grows. This behavior is most evident when you use the ADO parameters collection to make changes to the underlying spreadsheet.
It appears that the percentage that the file size grows is not determined by the number of updates that are completed, but by the size of the original Excel spreadsheet. This growth can sometimes be as much as double the original file size.
When you open and resave the Excel workbook in the Excel application, after the ADO updates have been applied, restores the workbook to a smaller size
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Behavior
Create the Excel Spreadsheet
Create the Visual Basic Project
Article ID: 293828 - Last Review: May 8, 2003 - Revision: 2.1