Help!

Data Refresh Speed

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  how to add Business Contact Manager to existing O..  
Author Message
rzester
External


Since: Nov 04, 2009
Posts: 1



PostPosted: Wed Nov 04, 2009 7:57 pm    Post subject: Data Refresh Speed
Archived from groups: microsoft>public>excel (more info?)

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?
Back to top
Charles Williams
External


Since: Apr 14, 2004
Posts: 96



PostPosted: Thu Nov 05, 2009 4:10 am    Post subject: Re: Data Refresh Speed [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

"rzester" <rzester DeleteThis @discussions.microsoft.com> wrote in message
news:96A9B497-2BD3-4ECB-B487-1321D3C4E4AC@microsoft.com...
>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?
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum