topic Excel Protected view problem in QlikView https://community.qlik.com/t5/QlikView/Excel-Protected-view-problem/m-p/316798#M116879 <HTML><HEAD></HEAD><BODY><P>Hi guys.</P><P>Let me explain the situation.</P><P>When I clicking on "export to excel" button in qlikview new document opened. </P><P>In my case sone documents open in Protected View mode (MS Office 2010).</P><P>After some try was discovered thats the problem in cyclic-group dimension&nbsp; "Date"</P><P>Which contain Year, YearQuart, YearMonth dimensions.</P><P>Problem appear only when Year was enamled and resulting excel contain empty Year column</P><P>After changing Year field to ='#'&amp;Year problem disapear.</P><P>Anyboady face such problems ?</P></BODY></HTML> Fri, 29 Jul 2011 08:47:04 GMT 2011-07-29T08:47:04Z Excel Protected view problem https://community.qlik.com/t5/QlikView/Excel-Protected-view-problem/m-p/316798#M116879 <HTML><HEAD></HEAD><BODY><P>Hi guys.</P><P>Let me explain the situation.</P><P>When I clicking on "export to excel" button in qlikview new document opened. </P><P>In my case sone documents open in Protected View mode (MS Office 2010).</P><P>After some try was discovered thats the problem in cyclic-group dimension&nbsp; "Date"</P><P>Which contain Year, YearQuart, YearMonth dimensions.</P><P>Problem appear only when Year was enamled and resulting excel contain empty Year column</P><P>After changing Year field to ='#'&amp;Year problem disapear.</P><P>Anyboady face such problems ?</P></BODY></HTML> Fri, 29 Jul 2011 08:47:04 GMT https://community.qlik.com/t5/QlikView/Excel-Protected-view-problem/m-p/316798#M116879 2011-07-29T08:47:04Z