Excel Optimization for XFGETCELL() / XFSETCELL()
Hi all,
Not sure if I'm in the right spot to post this question but here goes.
I recently downloaded a word document off the OneStream site (I think from Knowledge Base) called "Optimizing Excel for Quick Views and XFGETCELL()".
In that document there was a recommendation to change the default value from 2 to 4 in the Environment / Configuration Tab/ MultithreadingSettings property / "NumThreadsForGetDataCells" and "NumThreadsForSetDataCells".
Has anyone else tried this yet and did you realize any performance improvement in large Excel XFGETCELL() workbooks?
On a related note, does anyone have any other recommendations for optimization of Excel beyond the usual that has been presented here (i.e. Manual Calculation = on, Various preference settings, Refreshing in the Spreadsheet tool instead of in Excel, etc. etc.).
I feel like we've tried everything suggested at this point, except for the NumThreadsForGetDataCells configuration.
Thanks in advance for any advice.