Essbase Excel Addin Retrieve getting progressively worse with each retrieve

Hi all,

We have users complaining that their Essbase Excel Addin Retrieves are becoming progressively worse with each retrieve as the day goes on.  What starts as a 2 minute retrieve in the morning grow to 30+ minutes by noon.

Excel 2007, we upgraded to 11.2.1 last spring and this issue did not pop up until last month.  There were no configuration changes during that time and I have been able to duplicate the issue in all environments.

We have ruled out the server and network and I strongly suspect it may be a combination of Addin options and/or Excel settings.  They all know to only have one instance of Excel running and I’ve tried disabling FlashBack and setting Excel Calculations to manual, but that hasn’t helped.