web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Dynamic Exports with CRM 2011 Online, W8, IE10

(0) ShareShare
ReportReport
Posted on by 270

This is somewhat of a repost as my original post did not thoroughly get resolved.  Here's the scenario:

1.  CRM Online 2011, UR12

2.  Windows 8, IE10

3.  Set WIF 3.5

4.  Set Compatibility View

5.  Added site to trusted sites

6.  Added site to exclude pop up blocker

7.  Unchecked Disable script debugging

8.  Outlook client installed

 

When trying to export a dynamic spreadsheet, given the open to Save or Save As.  Select Save and then given the option to Open.  I can save it and open directly from Excel but it's not how things used to be.  When I open, get the following:

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="urn:schemas-microsoft-com:office:spreadsheet"><DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Author>Brenda Leon</Author><Created>2013-03-22T01:06:07Z</Created><Version>11.8132</Version></DocumentProperties><CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><MSCRMCreatePivot dt:dt="float">0</MSCRMCreatePivot></CustomDocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowHeight>9090</WindowHeight><WindowWidth>13260</WindowWidth><WindowTopX>480</WindowTopX><WindowTopY>45</WindowTopY><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles> </Styles><Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="Flagship Car Deals"><Names><NamedRange ss:Name="Query_from_Microsoft_CRM" ss:RefersTo="=R1C1:R2C1"/></Names>

<Table ss:ExpandedRowCount="2" ss:ExpandedColumnCount="1" ss:StyleID="s23" x:FullRows="1" x:FullColumns="1"><Column ss:StyleID="s23" ss:Width="227.25" ss:AutoFitWidth="0"/><Row><Cell ss:StyleID="s23"><Data ss:Type="String">To view and refresh dynamic data, Microsoft Dynamics CRM for Outlook must be installed. If it is already installed and configured, click "Refresh from CRM" to sign in to Microsoft Dynamics CRM.  If you do not want to be prompted again to sign in, click "Save my e-mail address and password" on the Sign In page.</Data><NamedCell ss:Name="Query_from_Microsoft_CRM"/></Cell></Row><Row><Cell ss:StyleID="s23"><Data ss:Type="String"></Data><NamedCell ss:Name="Query_from_Microsoft_CRM"/></Cell></Row></Table>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><Panes><Pane><Number>3</Number><ActiveRow>4</ActiveRow><ActiveCol>4</ActiveCol></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions><QueryTable xmlns="urn:schemas-microsoft-com:office:excel"><Name>Query from Microsoft CRM</Name><AutoFormatFont/><NoPreserveFormatting/><NoTitles/><OverwriteCells/><QuerySource><QueryType>Web</QueryType><EnableRedirections/><RefreshedInXl9/><EntirePage/><HTMLFormat>All</HTMLFormat><URLString xmlns:x="urn:schemas-microsoft-com:office:excel" x:HRef="https://<organization>crm.dynamics.com/_grid/print/print_data.aspx?tweener=1"/><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">exportType=listdata&gridXml=%3cgrid%3e%3csortColumns%3ename%3a1%3c%2fsortColumns%3e%3cpageNum%3e1%3c%2fpageNum%3e%3crecsPerPage%3e250%3c%2frecsPerPage%3e%3cdataProvider%3eMicrosoft.Crm.Application.Pla</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">tform.Grid.GridDataProviderQueryBuilder%3c%2fdataProvider%3e%3cuiProvider%3eMicrosoft.Crm.Application.Controls.GridUIProvider%3c%2fuiProvider%3e%3ccols%20%2f%3e%3cmax%3e-1%3c%2fmax%3e%3crefreshAsync%3</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">eFalse%3c%2frefreshAsync%3e%3cpagingCookie%20%2f%3e%3cenableMultiSort%3etrue%3c%2fenableMultiSort%3e%3cenablePagingWhenOnePage%3etrue%3c%2fenablePagingWhenOnePage%3e%3crefreshCalledFromRefreshButton%3</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">e1%3c%2frefreshCalledFromRefreshButton%3e%3ctotalrecordcount%3e56%3c%2ftotalrecordcount%3e%3callrecordscounted%3etrue%3c%2fallrecordscounted%3e%3creturntotalrecordcount%3etrue%3c%2freturntotalrecordco</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">unt%3e%3cgetParameters%3e%3c%2fgetParameters%3e%3cparameters%3e%3cautorefresh%3e1%3c%2fautorefresh%3e%3cisGridFilteringEnabled%3e1%3c%2fisGridFilteringEnabled%3e%3cviewid%3e%7b4A0C8AD2-A91C-E211-B070-</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">78E7D1623F9D%7d%3c%2fviewid%3e%3cviewtype%3e4230%3c%2fviewtype%3e%3cRecordsPerPage%3e250%3c%2fRecordsPerPage%3e%3cviewTitle%3eFlagship%20Car%20Deals%3c%2fviewTitle%3e%3clayoutXml%3e%26lt%3bgrid%20name</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">%3d%22resultset%22%20object%3d%223%22%20jump%3d%22name%22%20select%3d%221%22%20icon%3d%221%22%20preview%3d%221%22%26gt%3b%26lt%3brow%20name%3d%22result%22%20id%3d%22opportunityid%22%26gt%3b%26lt%3bcel</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">l%20name%3d%22name%22%20width%3d%22300%22%2f%26gt%3b%26lt%3bcell%20name%3d%22ownerid%22%20width%3d%22100%22%2f%26gt%3b%26lt%3bcell%20name%3d%22customerid%22%20width%3d%22150%22%2f%26gt%3b%26lt%3bcell%</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">20name%3d%22new_template%22%20width%3d%22100%22%2f%26gt%3b%26lt%3bcell%20name%3d%22new_licensing_stage%22%20width%3d%22150%22%2f%26gt%3b%26lt%3bcell%20name%3d%22new_deal_status%22%20width%3d%22100%22%</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">2f%26gt%3b%26lt%3bcell%20name%3d%22new_traffic_light%22%20width%3d%22100%22%2f%26gt%3b%26lt%3bcell%20name%3d%22new_deal_issue_type%22%20width%3d%22100%22%2f%26gt%3b%26lt%3bcell%20name%3d%22new_deal_is</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">sue_comment%22%20width%3d%22100%22%20disableSorting%3d%221%22%2f%26gt%3b%26lt%3b%2frow%26gt%3b%26lt%3b%2fgrid%26gt%3b%3c%2flayoutXml%3e%3cotc%3e3%3c%2fotc%3e%3cotn%3eopportunity%3c%2fotn%3e%3centitydi</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">splayname%3eDeal%3c%2fentitydisplayname%3e%3ctitleformat%3e%7b0%7d%20%7b1%7d%3c%2ftitleformat%3e%3centitypluraldisplayname%3eDeals%3c%2fentitypluraldisplayname%3e%3cisWorkflowSupported%3etrue%3c%2fisW</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">orkflowSupported%3e%3cfetchXmlForFilters%3e%26lt%3bfetch%20version%3d%221.0%22%20output-format%3d%22xml-platform%22%20mapping%3d%22logical%22%20distinct%3d%22false%22%26gt%3b%26lt%3bentity%20name%3d%2</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">2opportunity%22%26gt%3b%26lt%3battribute%20name%3d%22name%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22customerid%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22ownerid%22%20%2f%26gt%3b%26lt%3battribu</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">te%20name%3d%22new_licensing_stage%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22opportunityid%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_traffic_light%22%20%2f%26gt%3b%26lt%3battribute%20name%</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">3d%22new_deal_issue_type%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_deal_issue_comment%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_deal_status%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">22new_template%22%20%2f%26gt%3b%26lt%3border%20attribute%3d%22name%22%20descending%3d%22false%22%20%2f%26gt%3b%26lt%3bfilter%20type%3d%22and%22%26gt%3b%26lt%3bcondition%20attribute%3d%22name%22%20oper</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">ator%3d%22like%22%20value%3d%22FM5%25%22%20%2f%26gt%3b%26lt%3bcondition%20attribute%3d%22new_license_type%22%20operator%3d%22eq%22%20value%3d%22100000000%22%20%2f%26gt%3b%26lt%3b%2ffilter%26gt%3b%26lt</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">%3b%2fentity%26gt%3b%26lt%3b%2ffetch%26gt%3b%3c%2ffetchXmlForFilters%3e%3cisFetchXmlNotFinal%3eFalse%3c%2fisFetchXmlNotFinal%3e%3ceffectiveFetchXml%3e%26lt%3bfetch%20distinct%3d%22false%22%20no-lock%3</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">d%22false%22%20mapping%3d%22logical%22%20page%3d%221%22%20count%3d%22250%22%20returntotalrecordcount%3d%22true%22%26gt%3b%26lt%3bentity%20name%3d%22opportunity%22%26gt%3b%26lt%3battribute%20name%3d%22</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">name%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22customerid%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22ownerid%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_licensing_stage%22%20%2f%26gt%3b%2</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">6lt%3battribute%20name%3d%22opportunityid%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_traffic_light%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_deal_issue_type%22%20%2f%26gt%3b%26lt%3battr</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">ibute%20name%3d%22new_deal_issue_comment%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_deal_status%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_template%22%20%2f%26gt%3b%26lt%3battribute%20na</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">me%3d%22name%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22ownerid%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22customerid%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_template%22%20%2f%26gt%3b%</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">26lt%3battribute%20name%3d%22new_licensing_stage%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_deal_status%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_traffic_light%22%20%2f%26gt%3b%26lt%3ba</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">ttribute%20name%3d%22new_deal_issue_type%22%20%2f%26gt%3b%26lt%3battribute%20name%3d%22new_deal_issue_comment%22%20%2f%26gt%3b%26lt%3bfilter%20type%3d%22and%22%26gt%3b%26lt%3bcondition%20attribute%3d%</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">22name%22%20operator%3d%22like%22%20value%3d%22FM5%25%22%20%2f%26gt%3b%26lt%3bcondition%20attribute%3d%22new_license_type%22%20operator%3d%22eq%22%20value%3d%22100000000%22%20%2f%26gt%3b%26lt%3b%2ffil</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">ter%26gt%3b%26lt%3border%20attribute%3d%22name%22%20descending%3d%22false%22%20%2f%26gt%3b%26lt%3b%2fentity%26gt%3b%26lt%3b%2ffetch%26gt%3b%3c%2feffectiveFetchXml%3e%3cLayoutStyle%3eGridList%3c%2fLayo</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">utStyle%3e%3cenableFilters%3e%3c%2fenableFilters%3e%3cfetchXml%3e%26lt%3bfetch%20version%3d%221.0%22%20output-format%3d%22xml-platform%22%20mapping%3d%22logical%22%20distinct%3d%22false%22%26gt%3b%26l</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">t%3bentity%20name%3d%22opportunity%22%26gt%3b%26lt%3battribute%20name%3d%22name%22%2f%26gt%3b%26lt%3battribute%20name%3d%22customerid%22%2f%26gt%3b%26lt%3battribute%20name%3d%22ownerid%22%2f%26gt%3b%2</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">6lt%3battribute%20name%3d%22new_licensing_stage%22%2f%26gt%3b%26lt%3battribute%20name%3d%22opportunityid%22%2f%26gt%3b%26lt%3battribute%20name%3d%22new_traffic_light%22%2f%26gt%3b%26lt%3battribute%20n</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">ame%3d%22new_deal_issue_type%22%2f%26gt%3b%26lt%3battribute%20name%3d%22new_deal_issue_comment%22%2f%26gt%3b%26lt%3battribute%20name%3d%22new_deal_status%22%2f%26gt%3b%26lt%3battribute%20name%3d%22new</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">_template%22%2f%26gt%3b%26lt%3border%20attribute%3d%22name%22%20descending%3d%22false%22%2f%26gt%3b%26lt%3bfilter%20type%3d%22and%22%26gt%3b%26lt%3bcondition%20attribute%3d%22name%22%20operator%3d%22l</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">ike%22%20value%3d%22FM5%25%22%2f%26gt%3b%26lt%3bcondition%20attribute%3d%22new_license_type%22%20operator%3d%22eq%22%20value%3d%22100000000%22%2f%26gt%3b%26lt%3b%2ffilter%26gt%3b%26lt%3b%2fentity%26gt</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">%3b%26lt%3b%2ffetch%26gt%3b%0d%0a%3c%2ffetchXml%3e%3c%2fparameters%3e%3ccolumns%3e%3ccolumn%20width%3d%22300%22%20isHidden%3d%22false%22%20isMetadataBound%3d%22true%22%20isSortable%3d%22true%22%20labe</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">l%3d%22Topic%22%20fieldname%3d%22name%22%20entityname%3d%22opportunity%22%20renderertype%3d%22Crm.PrimaryField%22%3ename%3c%2fcolumn%3e%3ccolumn%20width%3d%22100%22%20isHidden%3d%22false%22%20isMetada</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">taBound%3d%22true%22%20isSortable%3d%22true%22%20label%3d%22Owner%22%20fieldname%3d%22ownerid%22%20entityname%3d%22opportunity%22%20renderertype%3d%22owner%22%3eownerid%3c%2fcolumn%3e%3ccolumn%20width</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">%3d%22150%22%20isHidden%3d%22false%22%20isMetadataBound%3d%22true%22%20isSortable%3d%22true%22%20label%3d%22Licensor%22%20fieldname%3d%22customerid%22%20entityname%3d%22opportunity%22%20renderertype%3</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">d%22customer%22%3ecustomerid%3c%2fcolumn%3e%3ccolumn%20width%3d%22100%22%20isHidden%3d%22false%22%20isMetadataBound%3d%22true%22%20isSortable%3d%22true%22%20label%3d%22Template%22%20fieldname%3d%22new</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">_template%22%20entityname%3d%22opportunity%22%20renderertype%3d%22picklist%22%3enew_template%3c%2fcolumn%3e%3ccolumn%20width%3d%22150%22%20isHidden%3d%22false%22%20isMetadataBound%3d%22true%22%20isSor</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">table%3d%22true%22%20label%3d%22Licensing%20Stage%22%20fieldname%3d%22new_licensing_stage%22%20entityname%3d%22opportunity%22%20renderertype%3d%22picklist%22%3enew_licensing_stage%3c%2fcolumn%3e%3ccol</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">umn%20width%3d%22100%22%20isHidden%3d%22false%22%20isMetadataBound%3d%22true%22%20isSortable%3d%22true%22%20label%3d%22Deal%20Status%22%20fieldname%3d%22new_deal_status%22%20entityname%3d%22opportunit</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">y%22%20renderertype%3d%22picklist%22%3enew_deal_status%3c%2fcolumn%3e%3ccolumn%20width%3d%22100%22%20isHidden%3d%22false%22%20isMetadataBound%3d%22true%22%20isSortable%3d%22true%22%20label%3d%22Traffi</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">c%20Light%22%20fieldname%3d%22new_traffic_light%22%20entityname%3d%22opportunity%22%20renderertype%3d%22picklist%22%3enew_traffic_light%3c%2fcolumn%3e%3ccolumn%20width%3d%22100%22%20isHidden%3d%22fals</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">e%22%20isMetadataBound%3d%22true%22%20isSortable%3d%22true%22%20label%3d%22Issue%20Type%22%20fieldname%3d%22new_deal_issue_type%22%20entityname%3d%22opportunity%22%20renderertype%3d%22picklist%22%3ene</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">w_deal_issue_type%3c%2fcolumn%3e%3ccolumn%20width%3d%22100%22%20isHidden%3d%22false%22%20isMetadataBound%3d%22true%22%20isSortable%3d%22false%22%20label%3d%22Issue%20Comment%22%20fieldname%3d%22new_de</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">al_issue_comment%22%20entityname%3d%22opportunity%22%20renderertype%3d%22ntext%22%3enew_deal_issue_comment%3c%2fcolumn%3e%3c%2fcolumns%3e%3c%2fgrid%3e&fetchXml=%3cfetch%20version%3d%221.0%22%20output-</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">format%3d%22xml-platform%22%20mapping%3d%22logical%22%20distinct%3d%22false%22%3e%3centity%20name%3d%22opportunity%22%3e%3cattribute%20name%3d%22name%22%2f%3e%3cattribute%20name%3d%22customerid%22%2f%</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">3e%3cattribute%20name%3d%22ownerid%22%2f%3e%3cattribute%20name%3d%22new_licensing_stage%22%2f%3e%3cattribute%20name%3d%22opportunityid%22%2f%3e%3cattribute%20name%3d%22new_traffic_light%22%2f%3e%3catt</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">ribute%20name%3d%22new_deal_issue_type%22%2f%3e%3cattribute%20name%3d%22new_deal_issue_comment%22%2f%3e%3cattribute%20name%3d%22new_deal_status%22%2f%3e%3cattribute%20name%3d%22new_template%22%2f%3e%3</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">corder%20attribute%3d%22name%22%20descending%3d%22false%22%2f%3e%3cfilter%20type%3d%22and%22%3e%3ccondition%20attribute%3d%22name%22%20operator%3d%22like%22%20value%3d%22FM5%25%22%2f%3e%3ccondition%20</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">attribute%3d%22new_license_type%22%20operator%3d%22eq%22%20value%3d%22100000000%22%2f%3e%3c%2ffilter%3e%3c%2fentity%3e%3c%2ffetch%3e%0d%0a&layoutXml=%3cgrid%20name%3d%22excelGrid%22%20select%3d%220%22</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">%20icon%3d%220%22%20preview%3d%220%22%3e%3crow%20name%3d%22result%22%20id%3d%22opportunityid%22%3e%3ccell%20name%3d%22name%22%20width%3d%22300%22%2f%3e%3ccell%20name%3d%22ownerid%22%20width%3d%22100%2</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">2%2f%3e%3ccell%20name%3d%22customerid%22%20width%3d%22150%22%2f%3e%3ccell%20name%3d%22new_template%22%20width%3d%22100%22%2f%3e%3ccell%20name%3d%22new_licensing_stage%22%20width%3d%22150%22%2f%3e%3cce</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">ll%20name%3d%22new_deal_status%22%20width%3d%22100%22%2f%3e%3ccell%20name%3d%22new_traffic_light%22%20width%3d%22100%22%2f%3e%3ccell%20name%3d%22new_deal_issue_type%22%20width%3d%22100%22%2f%3e%3ccell</x:WebPostString><x:WebPostString xmlns:x="urn:schemas-microsoft-com:office:excel">%20name%3d%22new_deal_issue_comment%22%20width%3d%22100%22%20disableSorting%3d%221%22%2f%3e%3c%2frow%3e%3c%2fgrid%3e%0d%0a</x:WebPostString><VersionLastEdit>2</VersionLastEdit><VersionLastRefresh>2</VersionLastRefresh></QuerySource><RefreshInfo> </RefreshInfo></QueryTable></Worksheet></Workbook>

 

*This post is locked for comments

I have the same question (0)
  • Mohammad Atif Profile Picture
    on at
    RE: Dynamic Exports with CRM 2011 Online, W8, IE10

    is this only happeing for Dynamic Export ot excel?

    is this happeing for any entity/ record?

    is this only happeing from Windows 8 achines ?

    Thanks,

  • Brenda Leon Profile Picture
    270 on at
    RE: Dynamic Exports with CRM 2011 Online, W8, IE10

    Yes to all of your questions.

  • Brenda Leon Profile Picture
    270 on at
    RE: Dynamic Exports with CRM 2011 Online, W8, IE10

    More information - from the Outlook client on the same view, when trying to perform dynamic export I get an error:

    <CrmScriptErrorReport>

     <ReportVersion>1.0</ReportVersion>

     <ScriptErrorDetails>

      <Message>Unable to get property 'performExcelExport' of undefined or null reference</Message>

      <Line>297</Line>

      <URL>/_grid/print/export_dlg.aspx?DuplicateColumnsPresent=0&PageRecordCount=56&TotalRecordCount=56&isFetchFinal=1&multipage=0&oid=&otc=3&viewid=%7b4A0C8AD2-A91C-E211-B070-78E7D1623F9D%7d&viewtype=4230</URL>

      <PageURL>/_grid/print/export_dlg.aspx?DuplicateColumnsPresent=0&PageRecordCount=56&TotalRecordCount=56&isFetchFinal=1&multipage=0&oid=&otc=3&viewid=%7b4A0C8AD2-A91C-E211-B070-78E7D1623F9D%7d&viewtype=4230</PageURL>

      <Function>Ok(e)</Function>

      <CallStack>

       <Function>Ok(e)</Function>

      </CallStack>

     </ScriptErrorDetails>

     <ClientInformation>

      <BrowserUserAgent>Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.2; WOW64; Trident/6.0; .NET4.0E; .NET4.0C; .NET CLR 3.5.30729; .NET CLR 2.0.50727; .NET CLR 3.0.30729; Zune 4.7; InfoPath.3; Microsoft Outlook 15.0.4420; Microsoft Outlook 15.0.4420)</BrowserUserAgent>

      <BrowserLanguage>en-US</BrowserLanguage>

      <SystemLanguage>en-US</SystemLanguage>

      <UserLanguage>en-US</UserLanguage>

      <ScreenResolution>1440x900</ScreenResolution>

      <ClientName>Outlook Laptop - Online</ClientName>

      <ClientTime>2013-03-22T11:07:27</ClientTime>

     </ClientInformation>

     <ServerInformation>

       <OrgLanguage>1033</OrgLanguage>

       <OrgCulture>1033</OrgCulture>

       <UserLanguage>1033</UserLanguage>

       <UserCulture>1033</UserCulture>

       <OrgID>{1BCBC5AB-9C12-4D8E-891C-ACE492DF613B}</OrgID>

       <UserID>{55944824-C6F8-4F42-A9F1-4A58568B4C41}</UserID>

       <CRMVersion>5.0.9690.3339</CRMVersion>

     </ServerInformation>

    </CrmScriptErrorReport>

  • Mohammad Atif Profile Picture
    on at
    RE: Dynamic Exports with CRM 2011 Online, W8, IE10

    From IE > Please go to reports, select Account Summary OOB report, and then do a Export to Excel and let me know if that is working or not?

    Thanks,

  • Brenda Leon Profile Picture
    270 on at
    RE: Dynamic Exports with CRM 2011 Online, W8, IE10

    Exporting the Account Summary report worked fine.

  • Mohammad Atif Profile Picture
    on at
    RE: Dynamic Exports with CRM 2011 Online, W8, IE10

    I am expecting this issue with the customization done on some entities. To verify this you may create a new test org and see if you are getting any error message for Export to Excel for that Org or not, if not then it will confirm that there is some customization that has been done into the org where you are facing this issue and it is nothing with Windows 8 or Outlook version here. I would suggest you to open a support case with us if it turn out to be a customization issue and we will look into this and more details to fix this issue.

    Thanks,

  • Brenda Leon Profile Picture
    270 on at
    RE: Dynamic Exports with CRM 2011 Online, W8, IE10

    Thank you Mohammad.  Unfortunately it's happening with all of my dynamic spreadsheets created from CRM 2011 using another on-prem environment.  So it's not just happening with my online version.  And it only started happening when I upgraded to W8, IE10, Office 2013.  I'll keep playing around with it and open a ticket if need be.  

  • Brenda Leon Profile Picture
    270 on at
    RE: Dynamic Exports with CRM 2011 Online, W8, IE10

    I just found a workaround that at least allows me to export and open dynamic spreadsheets directly from CRM as well as double clicking on them.

    I picked on of the files that had the IE icon and right clicked on it.

    Selected Open With...

    Selected Choose default program....

    Selected More Options (at the bottom)

    Select Look for More Apps on this PC

    Navigated to C:\Program Files\Microsoft Office 15\root\office15

    Selected excel.exe

    Once I did this on one of the files, all files with the IE symbol next to it changed to Excel.  When exporting from CRM, I get the option to Open or Save it (before I was only getting the option to Save).  When I open it, I have to enable content and hit the Refresh from CRM.  Not as easy as it was before, but at least it has gotten me to where I need to be.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
UllrSki Profile Picture

UllrSki 2

#3
SC-08081331-0 Profile Picture

SC-08081331-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans