PowerPivot does not run in Excel 2013 unless the user is an admin on the machine. Is this by design? And what's the fix? Seems a fix for this was issued for a previous version of Excel (KB2703880).
Error message when running PowerPivot in Excel 2013:
I just checked this on my test environment, I have Excel 2013 (15.0.4420.1017) MSO (15.0.4420.1017) 32-bit, when logged on with Users account, I could still open the PowerPivot, I checked serveral feature, also worked.
1st, try check for the latest update for your Office, and install them if you haven't.
2nd, since the Users account might not have enough permission to access network resources, check if there are any external data in your workbook.
If you can still use a workbook with local data source to reproduce this behavior, please provide the detail steps so we can check on it.
TechNet Community Support
Thanks for the suggestions. Please see below scenario which we tried, but to no avail:
- All updates were installed.
- This behavior manifested on a brand new workbook, so there wasn’t any external data.
Detailed steps were:
- Install excel 2013
- Get all updates
- Open Excel 2013
- Install the powerpivot add-in
- Attempt to open a (blank) PowerPivot data model
- Error messages, Powerpivot won’t start.
This problem does not happen with PowerPivot out of the box. I tested on two different systems where I logged in as a user that didn't have admin rights and PowerPivot worked without a problem.
This means something external to Excel is causing your problem. There is a known issue where if you have Analysis Services 2012 installed on the same machine that you will get this error. And as the article you pointed to says, the problem can also be caused by a group policy locking down necessary permissions for the user account. I would check both of these, first.
Microsoft Excel Support