TM1 Forum

I have a VBA routine that uses the QUSUBSET macro function to retrieve into an Excel worksheet a set of non-zero elements. I have been using this for some years now and it usually takes less than 5 seconds to execute. After upgrading to 10.1, it has now started taking between 30 and 60 seconds which is a serious problem since it not only results in slow performance for the user but additionally places a lock on the server. Any ideas on how to chase down and remedy this performance issue?

mitch23 wrote:I have a VBA routine that uses the QUSUBSET macro function to retrieve into an Excel worksheet a set of non-zero elements. I have been using this for some years now and it usually takes less than 5 seconds to execute. After upgrading to 10.1, it has now started taking between 30 and 60 seconds which is a serious problem since it not only results in slow performance for the user but additionally places a lock on the server. Any ideas on how to chase down and remedy this performance issue?

I know it's obvious but sometimes it's the little things that get us; have you confirmed that the calculation mode in Excel hasn't changed from manual to automatic?

I know it's obvious but sometimes it's the little things that get us; have you confirmed that the calculation mode in Excel hasn't changed from manual to automatic?

Yes.