topic Re: Can't pivot a tables exported from QlikView in QlikView https://community.qlik.com/t5/QlikView/Can-t-pivot-a-tables-exported-from-QlikView/m-p/429674#M1303312 <HTML><HEAD></HEAD><BODY><P>You might find this link helpful:</P><P><A href="http://answers.microsoft.com/en-us/office/forum/office_2007-excel/excel-2007-creating-a-pivot-table-and-i-get-this/6acf4cd8-3d39-4466-ac9d-a2d71f66b676">http://answers.microsoft.com/en-us/office/forum/office_2007-excel/excel-2007-creating-a-pivot-table-and-i-get-this/6acf4cd8-3d39-4466-ac9d-a2d71f66b676</A></P></BODY></HTML> Mon, 11 Mar 2013 19:45:34 GMT m_woolf 2013-03-11T19:45:34Z Can't pivot a tables exported from QlikView https://community.qlik.com/t5/QlikView/Can-t-pivot-a-tables-exported-from-QlikView/m-p/429673#M1303311 <HTML><HEAD></HEAD><BODY><P>When we export a QlikView table (straight table, version 11 qlikview) into excel (Office 2010, windows 7), some of our users are unable to create a pivot table. They get an error message "Data set reference is invalid".</P><P></P><P>There seems to be no logic about who can and can't do this. When data is copied from an excel sheet to a new sheet, pivoting works fine.</P><P></P><P>It's got to be a problem with either the users PC or their excel setup, but can anyone point me in the right direction ?</P><P></P><P>Thanks,</P><P></P><P>John</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Can-t-pivot-a-tables-exported-from-QlikView/m-p/429673#M1303311 2026-01-26T18:19:17Z Re: Can't pivot a tables exported from QlikView https://community.qlik.com/t5/QlikView/Can-t-pivot-a-tables-exported-from-QlikView/m-p/429674#M1303312 <HTML><HEAD></HEAD><BODY><P>You might find this link helpful:</P><P><A href="http://answers.microsoft.com/en-us/office/forum/office_2007-excel/excel-2007-creating-a-pivot-table-and-i-get-this/6acf4cd8-3d39-4466-ac9d-a2d71f66b676">http://answers.microsoft.com/en-us/office/forum/office_2007-excel/excel-2007-creating-a-pivot-table-and-i-get-this/6acf4cd8-3d39-4466-ac9d-a2d71f66b676</A></P></BODY></HTML> Mon, 11 Mar 2013 19:45:34 GMT https://community.qlik.com/t5/QlikView/Can-t-pivot-a-tables-exported-from-QlikView/m-p/429674#M1303312 m_woolf 2013-03-11T19:45:34Z Re: Can't pivot a tables exported from QlikView https://community.qlik.com/t5/QlikView/Can-t-pivot-a-tables-exported-from-QlikView/m-p/429675#M1303314 <HTML><HEAD></HEAD><BODY><P>Many thanks,</P><P></P><P>Looks like we're not alone !!</P><P></P><P>John</P></BODY></HTML> Tue, 12 Mar 2013 09:36:08 GMT https://community.qlik.com/t5/QlikView/Can-t-pivot-a-tables-exported-from-QlikView/m-p/429675#M1303314 2013-03-12T09:36:08Z