topic Problem using xlsx-files with data references in data analyzer? in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Problem-using-xlsx-files-with-data-references-in-data-analyzer/m-p/1247952#M2447 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P></P><P>Is there anybody that have experience trying to load xlsx-files - that contain data references - using the drag n drop function = data analyzer? It seems that the 'preparing data' load icon keep going forever.</P><P></P><P>If I copy all the content - using Excel - from one sheet in the Excel file and insert them as 'values' in a another sheet and the delete the original sheet, it works right away.</P><P></P><P>I know that this is a solution but not at very good one if you are trying to get people to use Qlik Sense as a self-service platform.</P><P></P><P>Br</P><P></P><P>Thomas </P></BODY></HTML> Mon, 14 Nov 2016 18:51:06 GMT Anonymous 2016-11-14T18:51:06Z Problem using xlsx-files with data references in data analyzer? https://community.qlik.com/t5/Connectivity-Data-Prep/Problem-using-xlsx-files-with-data-references-in-data-analyzer/m-p/1247952#M2447 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P></P><P>Is there anybody that have experience trying to load xlsx-files - that contain data references - using the drag n drop function = data analyzer? It seems that the 'preparing data' load icon keep going forever.</P><P></P><P>If I copy all the content - using Excel - from one sheet in the Excel file and insert them as 'values' in a another sheet and the delete the original sheet, it works right away.</P><P></P><P>I know that this is a solution but not at very good one if you are trying to get people to use Qlik Sense as a self-service platform.</P><P></P><P>Br</P><P></P><P>Thomas </P></BODY></HTML> Mon, 14 Nov 2016 18:51:06 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Problem-using-xlsx-files-with-data-references-in-data-analyzer/m-p/1247952#M2447 Anonymous 2016-11-14T18:51:06Z