Recently ran into this situation: Customer installed the wrong PowerPivot bits on their machine. They were running on a 64-bit OS with Office 2010 x64, but installed PowerPivot for Excel 32-bit. Everything installed OK, but when they clicked on the PowerPivot tab in Excel; then the PowerPivot Window they received the following error:
Embedded Analysis Services Engine: Could not open embedded PowerPivot data
Click OK
Embedded Analysis Services Engine: Could not open embedded PowerPivot data
Unable to load the VertiPaq engine (HRESULT 0×0800A03EC)
Solution: Uninstalled PowerPivot for Excel and installed the x64 bit version of PowerPivot. Everything now works.
There must be something strange about your install. When I try to install 32-bit PowerPivot with 64-bit Excel installed I get “This add-in requires Excel 2010. If you have 32-bit Excel, you must install the 32-bit version of the add-in. If not, you must install the 64-bit version. Go to http://go.microsoft.com/fwlink/?LinkId=168472“
[...] Click through to continue reading. [...]