Hi I am facing some serious problems with PowerPivot Addin 2010.

I have 3 versions of MS Office installed in my computer, 2007, 2010 & 2013. The reason i have to keep all version is beause i am a trainer and I may conduct the training on any version.

PowerPivot works fine in Excel 2013 but since the version incompatibility i am using excel 2010. Whenver i open PowerPivot it crashes abruptly. I tried reinstalling MS Office 2010 and also i uninstalled excel 2013 to ensure PowerPivot works fine, but no success.

In order to work I have switched my laptop temporarily to work on a report that requires 2010. But i have experienced a strange behaviour of PowerPivot. Whenever I add a field which is a numerical field, the data from other pivot automatically disappears. Earlier i was not able to add any field in the values section but after doing some reasearch i could figure out that its a glith in the software. in 2010 we can activate 2 field lists, one for normal pivot table and one for powerpivot. IN order to be able to add the fields properly we need to activate the field list of PowerPivot. 

Eventhough now i activated the powerpivot field list still when i try to add any other field the data from other pivot table which are created on the same data source automaticall gets removed. Please help asap as this is critical. 

Unfortunately i cant upload the data because its a customers confidential report that i am working on, also, I cant even recreate the same problem with the dummy data. I tried explaining as much as i could. 

Thanks and regards,

Hi,

Thanks for contacting us regarding the issue. Ive read through your post which was very informative and detailed and got a basic idea of the issue, yet I still need some information for assisting you better, I hope you dont mind.

1. Did you get any errors when you open PowerPivot in Excel 2010? Any errors in Events log?
2. Was your Office all 32 bits or 64 bits?
3. By In order to work I have switched my laptop temporarily to work on a report that requires 2010. Do you mean youve separated Office 2010 and other versions of Office to separate computer?
4. I have some difficulty of understand activated the PowerPivot field, could you explain this a bit more, if you have a screen grab which would be very helpful.
5. Whenever I add a field which is a numerical field, the data from other pivot automatically disappears Im also a bit confused about this. Do you mean if you add a numerical field, the data in other Pivot field will disappear?

Ive tried from my side: Installed Office 2010 and Office 2013 on 1 Windows 8.1 computer; Tried created PowerPivot with Both Excel 2010 and Excel 2013; Issue cant be reproduced.

Based on the information we have at the moment, we can try some basic steps below:

1. Before we start
   • Make sure your download PowerPivot for Excel 2010 is correct: Download address.
   • Make sure your computer meet Installation Requirements.
2. As I cant reproduce it from my side, I suspect it might be caused by other add-ins or software conflict, we can do following steps to narrow it down.
   • Perform a clean boot: Refer steps, try creating a PowerPivot from Excel 2010, see if it works.
   • If clean boot didnt solve the issue, start Excel 2010 in safe mode, then enable PowerPivot related add-in only, see if it solve the issue.

This article describe Version compatibility between Power Pivot Data Models in Excel 2010 and Excel 2013 which is for your reference.

Please provide the information in section 1 if none of the steps working for you in section 2.

Note: Though I understand your situation, installing multiple versions of Office on 1 computer is not recommended, it could lead many issues during usage.

Hi,

How did it go? Are you still facing the issue?