locked
How can I get Power Pivot to use more than one core RRS feed

  • Question

  • Hi,

    I am using Excel 2013 64 Bit. I am running Excel on a server as a remote desktop. I notice that when I run any given task, e.g. create a relationship between two tables I have to wait several minutes. I have 20 processor cores on this server and at the moment Excel only seems to be using one of them. So how can I get Excel to spread it's load over the rest of the processor cores?

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Tuesday, May 12, 2015 4:35 PM

Answers

  • Hi Kieran,

    According to your description, you need to configure PowerPivot to use more than one core, so that you needn't to wait long time when running any given task, right?

    One important new feature of Excel 2013 is that it no longer supports MDI (Multiple Document Interface) and it now uses the SDI (Single Document Interface) paradigm. With this new behavior, every Excel document opens a window handled by the same Excel process. What we can do is running Excel 2013 in a separate instance, with this method parallel running of code is possible in excel 2013. Please refer to the link below to see the details.
    http://sqlblog.com/blogs/marco_russo/archive/2012/07/24/running-excel-2013-in-a-separate-instance-excel-powerpivot.aspx

    Regards,


    Charlie Liao
    TechNet Community Support

    Wednesday, May 13, 2015 2:26 AM