I made a query to pull data from our database, and ran it in my excel sheet. The query returned fine, and all the data was populated, but the next time I ran it, it just basically inserted columns for the new data and left the old data sitting there to the right.

I thought it might have something to do with the RefreshStyle option being set to xlInsertDeleteCells, but I could never really find out any information on this option.

Please Login or Register  to view this content.