Hello,

I am working on a project that is based on Excel macro (VBA).

Now company need to upgrade the excel version to 2013. So I downloaded trial version and testing all the developed tool on excel 2013.

The problem I am facing is that macro is running very slowly,especially when it changes content of cell or change color of it.

I tried running .xls file and also tried after upgrading the .xls file to .xlsm

For the process which was taking 1 sec to complete in excel 2003 is taking more then 1 min in excel 2013

means there can be any problem in environment setting or else

Some Information about excel tools

1. The excel macro contents connection to postgre database. For this I am using OBDC connection
2. The excel tool contains pivot tables for showing the reports. The pivot tables are refreshed by VBA coding

Looking for help

thanks and best regards.