Colin Phillips (Alumni)
When trying to connect to data in PowerPivot everything seems to work fine when you’re setting up your data connections, setting up your relationships, and then once you go to return back to the Excel window by virtue of creating a PivotTable, you suddenly see the following error.
Message:
Excel Window: PowerPivot Field List
Details:
============================
Error Message:
============================
Exception from HRESULT: 0x800A03EC
============================
Call Stack:
============================
Server stack trace:
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Office.Interop.Excel.PivotCache.CreatePivotTable(Object TableDestination, Object TableName, Object ReadData, Object DefaultVersion)
at Microsoft.AnalysisServices.Modeler.FieldList.GeminiRibbon.CreatePivot(PivotCache cache, Worksheet workSheet, Int32 rowIndex, Int32 colIndex, Object pivotVersion, SASlicerHost slicerHost)
at Microsoft.AnalysisServices.Modeler.FieldList.GeminiRibbon.InsertPivot(String sandboxConnectionString, String location, String cubeName, MultiObjectsReportType reportType)
============================
It doesn’t actually matter what your data is (whether you have 1 table or 50), how many relationships you have (or if you even have any), or how large your data set is (4 rows or 4 million). It also isn’t an indication of corruption, or your version of Excel, PowerPivot, or anything of the sort.
It turns out that Excel in this instance ends up in Compatibility Mode (even though you’re trying to use new features not available in compatibility mode). To exit compatibility mode, go to the File menu, select Info from the left column, and under the category Compatibility Mode choose Convert.
Reference:
http://www.mrexcel.com/forum/excel-questions/496335-power-pivot-question.html
The reason this happens is that your default file format is set to “Excel 97-2003 Workbook”, and not the modern “Excel Workbook” format. To change this setting, follow the link below.