{"id":1593,"date":"2022-08-30T15:17:49","date_gmt":"2022-08-30T15:17:49","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/27\/problem-about-power-pivot-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:17:49","modified_gmt":"2022-08-30T15:17:49","slug":"problem-about-power-pivot-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/problem-about-power-pivot-collection-of-common-programming-errors\/","title":{"rendered":"problem about power-pivot-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums power-pivot<br \/>\nI recently encountered a strange, yet repeatable, bug that popped up during a training session I was doing with 5 users. We were all using Excel 2013 \/ PowerPivot to extract data from SSAS MDM 2012. We all got the following error when attempting to refreshthe Pivot Table from the Excel side: Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.Exception from HRESULT: 0x800AC472.See here for the<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums power-pivot<br \/>\nHi All,I&#8217;m getting the following error in a SQLDUMPER.exe CMD box\u00a0when trying to use a slicer in powerpivots,Unable to open file \\\\?\\c:\\program files\\microsoft analysis services\\as oleddb\\10\\flightrecordercurrent.trc, error 2I&#8217;ve googled and found others that have had the same problem, some which were fixed by reinstalled powerpivots, unfortunately that fix didn&#8217;t work for me, any ideas?Thanks,Mark<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums power-pivot<br \/>\nI am using powerpivot v2 with excel 2010.When I go to my excel file&#8217;s powerpivot and I try to insert a formula in any column, I constantly get the following message:\u00a0&#8220;unhandled exception has occurred in a component in your application. If you click continue, the application will ignore this error and attempt to continue&#8221;.************** Exception Text **************System.InvalidCastException: Return argument has an invalid type.\u00a0 \u00a0at System.Runtime.Remoting.Proxies.RealP<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums power-pivot<br \/>\nI&#8217;ve just upgraded to PowerPivot &#8216;v2&#8217; (11.0.2100.60) and now a powerpivot table created in &#8216;v1&#8217; throws an Unhandled Exception.A rollover of the\u00a0powerpivot tab reports that &#8216;one or more formulas have errors&#8217; but the table itself doesn&#8217;t display when clicked, I\u00a0instead receive an Unhandled Exception error: &#8220;Index was out of range. Must be non-negative and less than thesize odf the collection. Parameter name: index&#8221;Can anyone shed any light on what I might need to do to resolve<\/li>\n<\/ul>\n<p id=\"rop\"><small>Originally posted 2013-11-27 11:58:44. <\/small><\/p>","protected":false},"excerpt":{"rendered":"<p>msdn sql-server-forums power-pivot I recently encountered a strange, yet repeatable, bug that popped up during a training session I was doing with 5 users. We were all using Excel 2013 \/ PowerPivot to extract data from SSAS MDM 2012. We all got the following error when attempting to refreshthe Pivot Table from the Excel side: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1593","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1593"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1593\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}