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!!