topic Import Excel To Pivot With Macros in QlikView https://community.qlik.com/t5/QlikView/Import-Excel-To-Pivot-With-Macros/m-p/311947#M115146 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P> <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Hi everyone, I have a pivot table in Qlikview and an external excel sheet that needs to update that pivot table if anyone make changes to the excel sheet. But I don’t want the clients to refresh the model every time, So I would like to know if there is a way to do this through macros. If possible, can anyone help and explain how to do this.</SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Kind Regards</SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">And thanks in advance.</SPAN></P></BODY></HTML> Thu, 23 Feb 2012 09:13:28 GMT stevietm 2012-02-23T09:13:28Z Import Excel To Pivot With Macros https://community.qlik.com/t5/QlikView/Import-Excel-To-Pivot-With-Macros/m-p/311947#M115146 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P> <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Hi everyone, I have a pivot table in Qlikview and an external excel sheet that needs to update that pivot table if anyone make changes to the excel sheet. But I don’t want the clients to refresh the model every time, So I would like to know if there is a way to do this through macros. If possible, can anyone help and explain how to do this.</SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Kind Regards</SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">And thanks in advance.</SPAN></P></BODY></HTML> Thu, 23 Feb 2012 09:13:28 GMT https://community.qlik.com/t5/QlikView/Import-Excel-To-Pivot-With-Macros/m-p/311947#M115146 stevietm 2012-02-23T09:13:28Z