Due to many and frequent questions on the topic of performance when exporting to MS Excel on RTC, I’ve summarized some of the answers in this blog to try and explain the impact of running MS Office automation objects on RTC.
I have been struggling with exporting data from Dynamics NAV to Excel Spreadsheets including formulas lately. I had the problem with a custom developed export to excel so I checked the code in the Excel Buffer table to see how standard Navision solved the problem only to see that the problem also existed in standard NAV too.
Vertalen
