{"id":702,"date":"2013-03-12T11:38:40","date_gmt":"2013-03-12T18:38:40","guid":{"rendered":"https:\/\/mmman.itgroove.net\/?p=702"},"modified":"2023-02-24T21:48:48","modified_gmt":"2023-02-24T21:48:48","slug":"error-excel-window-powerpivot-field-list-resolved","status":"publish","type":"post","link":"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/","title":{"rendered":"Error \u201cExcel Window: PowerPivot Field List\u201d Resolved"},"content":{"rendered":"

When trying to connect to data in PowerPivot everything seems to work fine when you\u2019re 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.<\/p>\n

 <\/p>\n

Message:<\/p>\n

Excel Window: PowerPivot Field List<\/p>\n

 <\/p>\n

Details:<\/p>\n

============================
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)
============================<\/font><\/p>\n

  <\/p>\n

It doesn\u2019t 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\u2019t an indication of corruption, or your version of Excel, PowerPivot, or anything of the sort.  <\/p>\n

It turns out that Excel in this instance ends up in Compatibility Mode (even though you\u2019re trying to use new features not available in compatibility mode).  To exit compatibility mode, go to the File<\/strong> menu, select Info<\/strong> from the left column, and under the category Compatibility Mode<\/strong> choose Convert<\/strong>. <\/p>\n

Reference: <\/p>\n

http:\/\/www.mrexcel.com\/forum\/excel-questions\/496335-power-pivot-question.html<\/a> <\/p>\n

The reason this happens is that your default file format is set to \u201cExcel 97-2003 Workbook<\/strong>\u201d, and not the modern \u201cExcel Workbook<\/strong>\u201d format.  To change this setting, follow the link below. <\/p>\n

http:\/\/support.microsoft.com\/kb\/2629973<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

When trying to connect to data in PowerPivot everything seems to work fine when you\u2019re 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 … <\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[21,24,30],"tags":[],"acf":[],"yoast_head":"\nError \u201cExcel Window: PowerPivot Field List\u201d Resolved - Archive<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error \u201cExcel Window: PowerPivot Field List\u201d Resolved - Archive\" \/>\n<meta property=\"og:description\" content=\"When trying to connect to data in PowerPivot everything seems to work fine when you\u2019re 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 …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/\" \/>\n<meta property=\"og:site_name\" content=\"Archive\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-12T18:38:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T21:48:48+00:00\" \/>\n<meta name=\"author\" content=\"Colin Phillips (Alumni)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Colin Phillips (Alumni)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/\",\"url\":\"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/\",\"name\":\"Error \u201cExcel Window: PowerPivot Field List\u201d Resolved - Archive\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#website\"},\"datePublished\":\"2013-03-12T18:38:40+00:00\",\"dateModified\":\"2023-02-24T21:48:48+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Archive\",\"item\":\"https:\/\/regroove.ca\/archive\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error \u201cExcel Window: PowerPivot Field List\u201d Resolved\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/archive\/#website\",\"url\":\"https:\/\/regroove.ca\/archive\/\",\"name\":\"Archive\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/archive\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\",\"name\":\"Colin Phillips (Alumni)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"caption\":\"Colin Phillips (Alumni)\"},\"url\":\"https:\/\/regroove.ca\/archive\/author\/cphillips\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Error \u201cExcel Window: PowerPivot Field List\u201d Resolved - Archive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/","og_locale":"en_US","og_type":"article","og_title":"Error \u201cExcel Window: PowerPivot Field List\u201d Resolved - Archive","og_description":"When trying to connect to data in PowerPivot everything seems to work fine when you\u2019re 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 …","og_url":"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/","og_site_name":"Archive","article_published_time":"2013-03-12T18:38:40+00:00","article_modified_time":"2023-02-24T21:48:48+00:00","author":"Colin Phillips (Alumni)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Colin Phillips (Alumni)","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/","url":"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/","name":"Error \u201cExcel Window: PowerPivot Field List\u201d Resolved - Archive","isPartOf":{"@id":"https:\/\/regroove.ca\/archive\/#website"},"datePublished":"2013-03-12T18:38:40+00:00","dateModified":"2023-02-24T21:48:48+00:00","author":{"@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/archive\/2013\/03\/12\/error-excel-window-powerpivot-field-list-resolved\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Archive","item":"https:\/\/regroove.ca\/archive\/"},{"@type":"ListItem","position":2,"name":"Error \u201cExcel Window: PowerPivot Field List\u201d Resolved"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/archive\/#website","url":"https:\/\/regroove.ca\/archive\/","name":"Archive","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/archive\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b","name":"Colin Phillips (Alumni)","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","caption":"Colin Phillips (Alumni)"},"url":"https:\/\/regroove.ca\/archive\/author\/cphillips\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/702"}],"collection":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/comments?post=702"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/702\/revisions"}],"predecessor-version":[{"id":1961,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/702\/revisions\/1961"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/media?parent=702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/categories?post=702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/tags?post=702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}