Clear Pivot Table Cache during loop execution

Hello,

I have a tool that was developed which is used to summarize large amounts of data. It was working well on files input until it exceeded 110 MB. At this point it exceeded excel's memory capability (32 bit).

I am pasting the debug dock below. For some reason now its failing for a small 70 MB input file and i can't figure out why. Someone recommended that I clear the Pivot table cache on each iteration to solve this problem. 

Any assistance would be much appreciated.

Thank you 

Len 

Before bringing up excel:

After bringing up Excel with shell:

After starting analysis:

Same spot as before: