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.
