topic Quick Excel question. in QlikView https://community.qlik.com/t5/QlikView/Quick-Excel-question/m-p/91121#M764735 <HTML><HEAD></HEAD><BODY><P>I'm almost positive some people in here know how to use excel and could tell em why i am getting this error.</P><P></P><P>I understand that this isn't really the purpose of this forum but no one would answer my questions on the excel.forums.com site.</P><P></P><P>Data!$A:$A, Data!$B:$B, Data!$D:$D, Data!$F:$F, Data!$H:$H </P><P>I need a table of these columns, I am using a pivot table to make them. When i have selected them and press the finish button</P><P></P><P>\!/</P><P><IMG alt="invalid.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207949_invalid.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Quick Excel question. https://community.qlik.com/t5/QlikView/Quick-Excel-question/m-p/91121#M764735 <HTML><HEAD></HEAD><BODY><P>I'm almost positive some people in here know how to use excel and could tell em why i am getting this error.</P><P></P><P>I understand that this isn't really the purpose of this forum but no one would answer my questions on the excel.forums.com site.</P><P></P><P>Data!$A:$A, Data!$B:$B, Data!$D:$D, Data!$F:$F, Data!$H:$H </P><P>I need a table of these columns, I am using a pivot table to make them. When i have selected them and press the finish button</P><P></P><P>\!/</P><P><IMG alt="invalid.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207949_invalid.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Quick-Excel-question/m-p/91121#M764735 Anonymous 2020-11-25T16:16:04Z Re: Quick Excel question. https://community.qlik.com/t5/QlikView/Quick-Excel-question/m-p/91122#M764736 <HTML><HEAD></HEAD><BODY><P>I presume Excel doesn't like the data ranges being non-contiguous</P></BODY></HTML> Mon, 16 Jul 2018 14:39:40 GMT https://community.qlik.com/t5/QlikView/Quick-Excel-question/m-p/91122#M764736 m_woolf 2018-07-16T14:39:40Z Re: Quick Excel question. https://community.qlik.com/t5/QlikView/Quick-Excel-question/m-p/91123#M764737 <HTML><HEAD></HEAD><BODY><P>Yea I eventually figured that.</P></BODY></HTML> Mon, 16 Jul 2018 14:45:30 GMT https://community.qlik.com/t5/QlikView/Quick-Excel-question/m-p/91123#M764737 Anonymous 2018-07-16T14:45:30Z