PDA

View Full Version : Out of memory / resource - XML import



theta
03-14-2011, 10:07 AM
Hi

My machine (core i7, solid state drive, 4gb DDR3) is being very strange when importing XML.

I am using Excel 2007

Wa working fine for 2 weeks, now having issues when importing, running out of resource I think.

Even when I get it into excel, I can pivot the data...but then run a macro to filter the pivot > copy result to new sheet > filter pivot > copy result to new sheet loop etc...

Excel keeps munching up the ram.

Any way to save the workbook mid-macro to free up RAM.

Very annoying as some days it runs no problems. Other days won't even import the XML file (70mb)...or even smaller files (30mb) that it would crunch without issues.

Thoughts?

Mid-macro saves, memory leaks, ... ?

Jan Karel Pieterse
03-14-2011, 10:50 AM
Any chance on seeing your code?