Data Refresh Speed

[rzester]

I have a spreadsheet that extracts data from Sharepoint and then performs
multiple calculations on that data. When I refresh the data, it then also
recalculates every formula and this is starting to take a long time due to
the sheer number of calculations that are being performed.

I'm wondering if there is anything I can do to speed up the processing, like
multi-threading or something? Any settings or options I can change to make
this faster?

 

[Charles Williams]

See my website

http://www.decisionmodels.com/

and white paper
http://msdn.microsoft.com/en-us/library/aa730921.aspx


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com