I have several workbooks that use an XMLMap to import XML data. The data usually includes about 200 single cells and 20 tables about 400 rows and 5 columns each. When I set up this XMLMap in a blank workbook the import is nearly instant, but with a complex workbook like I need to use it in, it takes about 20 seconds to import. My complex workbooks have hundreds of thousands of formulas and many spreadsheets.
I have calculations turned to manual, screen updating turned off, I've tried removing autofiltering on the sheets.
I've been working on this for several days and can't seem to get anywhere. If I delete large portions of the formulas, the import happens faster. Are there any known issues with the workbooks complexity affecting data import? Are there any things I haven't tried yet?
I'm leveraging VSTO for visual studios to run this in C#, but the speed is also slow in VBA and using the import button on the developer menu of the ribbon.
Thanks a ton!!!
Bookmarks