XFGETCELL(), XFSETCELL() PERFORMANCE

Hi all,

Every forecast cycle we get the same performance complaints from the same region group of users.  They are always uploading massive amounts of data and refreshing massive amounts of data in the same workbooks using the XF functionality in Excel.

To be clear, we have tried multiple times to convince them that they should be importing that data via CSV and advising that they will not get the same performance using the XF functions.  

We have also tried having OneStream re-index the databases before these cycles and we have regular daily app pool recycles.

The OneStream data logs really don't show any significant refresh issues (less than 5 minutes usually) but the one user doing all this work is insisting that it's taking hours and hours to finish refreshing and they often have to close and reopen Excel and re-launch OneStream.

We have raised multiple tickets and OneStream does not see any back end issues.

We have looked at their Excel preferences and tried different options there but no improvement.

I am 100% out of ideas so if anyone out there has any thoughts, would love to hear what you've done to resolve these issues.

I'm going to post this as well somewhere in the community where Excel discussions happen.

Thanks for any advice.