File size and pivot table refresh problems
 

I have written a very large macro, that pulls data from access via sql
statements -- copies and pastes data to new workbook then creates and
refreshes a pivot table in the new workbook. The pasted data is appox. 26
col by 500 rows. When I try and refresh the pivot table, i get the continue
without undo prompt followed by the out of memory msg. I noticed that the
file size of the new workbook is 15mb and have no idea why it is this large.
Any ideas? can I clear the memory before the refresh?

Thanks in advance.

Dmoney