QUSUBSET Performance Problem
-
mitch23
- Posts: 21
- Joined: Thu Jan 29, 2009 11:32 am
- OLAP Product: Planning Analytics
- Version: 10.1
- Excel Version: Office 365
QUSUBSET Performance Problem
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?
-
Alan Kirk
- Site Admin
- Posts: 6665
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: QUSUBSET Performance Problem
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?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?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
mitch23
- Posts: 21
- Joined: Thu Jan 29, 2009 11:32 am
- OLAP Product: Planning Analytics
- Version: 10.1
- Excel Version: Office 365
Re: QUSUBSET Performance Problem
Yes.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?