Hi thanks for you response.

I have unticked "Autofit column widths on update" and retained "Preserve cell formatting on update"options in pivot options. I believe this is to do more with Data cache as read in one of the thread in this forum. I am trying with options provided in the threads.

Let check it!!!