Slow exports from MS Project to Excel
Hello,
I have a number of macros in MS Project that export data from MS Project to
Excel. These have worked great up until upgrading Excel. My old
configuration was MS Project 2007 and MS Excel 2003. Since upgrading to MS
Excel 2007 it takes considerably longer to run the macros. Additionally, a
coworker who was already on MS Excel 2007 but recently upgraded to MS Project
2007 (though they never used the macros prior to Project 2007) is finding
them to be exceptionally slow as well. Unfortunately, I have no ability to
give any metrics on how long it took prior to the upgrade and how long it is
taking now, but it is a considerable difference. Has anyone else experienced
this and if so, is there a solution? I've done some searches and have found
nothing so far. Let me know if it is critical to see an example of one of
the macros to troubleshoot this.
Thanks!
|