Progressing to 64 bit

Use this forum for any general discussion and questions about Excel
pfreins
Posts: 2
Joined: Mon Aug 04, 2014 9:29 pm

Progressing to 64 bit

Postby pfreins » Tue Aug 05, 2014 2:09 am

We are preparing to approach our IT group with a proposal for transition to 64 bit Windows / Office. In preparation for the conversation, I’m looking for a few reputable articles that spell out why Power Pivot legitimately requires a 64 bit environment to work properly. Can anyone share links to any professionally written articles of this nature?

MattAllington
Posts: 845
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Progressing to 64 bit

Postby MattAllington » Tue Aug 05, 2014 6:20 am

Hi Paul. My recommendation is to simply set up a trial with IT. Create a model with 1 million rows of data, and run it on 2 different PCs, one with 32 bit and one with 64 bit side by side. That is all the evidence you will need. I have data models that I use with 15 million rows, so 1 million is not big by any means.

This is not a case of "nice to have". At one of my clients, I told them to install 64bit. iT decided to install 32 bit instead. They had done 50% of the conversions before I discovered what was going on. The first model I sent to a user with 32 bit simple did not work on the 32 bit version. He had an old PC, so I wasn't sure it it was the PC or the software. We swapped over to 64 bit and it worked fine immediately. So IT had to start again and reinstall all the PCs that had 32 Bit installed.
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

pfreins
Posts: 2
Joined: Mon Aug 04, 2014 9:29 pm

Re: Progressing to 64 bit

Postby pfreins » Tue Aug 05, 2014 9:16 pm

Hmmm. Sounds grand, but the 64 bit machine to compare to does not exist within my reach. I agree that this is not a case of "nice to have". If I could point to a reputably published article, that might help validate my request. Thanks for your response.

MattAllington
Posts: 845
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Progressing to 64 bit

Postby MattAllington » Wed Aug 06, 2014 6:21 am

If I had both versions, I would do a demo for you. In fact I will definitely do this once I can find a copy of Excel 2010 - it is proving hard to find. But maybe you don't need it. Just create a model like I mentioned and run in in the 32 bit version - it is sure to fail!
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax


Return to “Excel”

Who is online

Users browsing this forum: No registered users and 1 guest