I'm testing an Excel application run on a Windows Server 2003 box.
Data retrieval is about 5x faster, which is what I expected. However,
the app is bogging down adding data from an Access table using the
Cells(iRow,iCol) function in a long double loop (6000+ rows).

I discovered that Excel is outputting a large number of EMF files to
the Temporary Internet Files\Content.MSO directory during this loop.
Making matters worse, McAffee is virus scanning each and every EMF
file.

I'd like to prevent Excel from generating these unneeded files in the
first place. Anyone have any idea how to prevent it? Is this a bug?

Files range in size from 3K to 25K or so.

Since this is a representative of many legacy Excel applications that
we're considering running on our own server for performance purposes,
rewriting large sections of the code is not my best option. I'm hoping
there's a simple setting change available either through VBA code,
options or registry.

Any ideas?

--Nick

I figured it out myself. It was an add-in. I unchecked all the
add-ins I didn't need and voila! no more emf files and therefore no
more performance issues.