Cluster PC's for complex excel models

**pauldaddyadams** · 06-19-2012, 07:54 AM

Hi,

I have an excel file which takes hours to calculate as it contains many different formulas accross over 350 sheets. I know some people will crtise the model but it is built now and I need to use it in this format if possible.

I noticed online that Excel 2010 has the function which enables calculations to be shared across multiple PC’s – is this correct? If so does anyone know of any companys that offer this service?

Do I need to set the spreadsheet out in a set format?

Regards

Paul

**romperstomper** · 06-19-2012, 08:41 AM

Here's a good blog post on the subject which mentions the API that you need: http://blogs.office.com/b/microsoft-...c-cluster.aspx
and there's a whitepaper here: http://www.microsoft.com/en-us/downl....aspx?id=21238

You'd need to redesign your application anyway to create cluster UDFs, which I think have to be in XLLs.

**pauldaddyadams** · 06-19-2012, 09:32 AM

Thanks Romperstomer

Are their any companies that have the cluster set up already which alowes clients to pay a service fee for their data to be processed?