PowerPivot Crashing


I'm hoping someone can help me on this. I have several PowerPivot users that have repeated issues of PowerPivot crashing on refresh, or even corrupting when opening.

Here are the some details and I can provide more:

1) Running 64-bit Windows 7, ~6Gb RAM in each computer, dual core
2) Running 32-bit MS Office 2010
3) Users are pulling between 1-3 million rows of data from SQL Server 2000 (and yes, I       would love to upgrade to a platform that's not 13 years old!)
4) The error messages all vary but I can post some of them if needed but the common complaints I'm getting are: "it takes 45+ minutes to open the spreadsheet"," it crashed when I open it", "it won't let me save anything", or "I tried refreshing and it just errors out."

All users have at some point removed and reinstalled the PowerPivot addon, as that seems to be a common solution. However, that doesn't seem to be working.

I just don't know enough about PowerPivot to give them any direction. Should office be upgraded to 64-bit or will that not matter?

I'm at a loss here, so any help would be greatly appreciated!!


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Office should be 64 bit or you will incur some issues, however it does appear to be an available memory issue. This is a lot to read but Charles Williams is a man of note when it comes to memory and speed issues with Excel, read this through and see where you can save memory whilst Excel is running http://msdn.microsoft.com/en-us/library/ff700515(v=office.14).aspx (dont forget to get your users to document how many applications they have running or browser windows open...etc).


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
uga_godawgsAuthor Commented:
Hi Simon,

Thanks for the article - it was a great read! I have one question about changing up to 64 bit that I can't seem to get a definitive answer on, so perhaps you know. It seems that even MS does not recommend going up to 64bit (hence the default to 32bit on the install) and it seems due to the fact that add-ins and such are all designed for 32bit, not 64bit. Is this really an issue, still? It seems 64bit is the way to go for my users but before I make that call, I want to make sure there is no real "down-side" to changing.

Thanks in advance!

It depends on your situation, i'm not saying that the 32 bit version is entirely your issue, there are many factors that can cause problems and my main point was your available memory when running MS Office.

If you have anything coded (VBA) in the 32 bit version it will probably NOT work on the 64 bit (http://office.microsoft.com/en-gb/word-help/choose-the-32-bit-or-64-bit-version-of-office-HA010369476.aspx), a lot of add-ins are now being rewritten in 64 bit but you cant rely on the ones you want being ported already, Active Sync doesn't work with 64 bit.

On the plus side you can create a 2GB excel file so great if you have tonnes of data. In all honesty if you are having memory issue now then the 64 bit is hungrier, if you do create huge Excel files....etc you'll need that much more ram and processing power to open them.

Stick with the 32 bit and iron out the issue you have, if possible try the same application on another machine with the same memory (and the same applications open at the same time) if you have the same issues then you know its the memory.


P.S if you do decide to upgrade think of who your recipients are of your worksheets...etc and will they be able to use your creations from a 64 bit model.
uga_godawgsAuthor Commented:
Thanks Simon!
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft PowerPoint

From novice to tech pro — start learning today.