I tried to read the data using read range in excel application scope to write the data into other excel sheet for refresh the pivot table. But, when i tried to read and write, read is done properly and while writing into other excel, i need to wipe out the existing entries in the excel and replace with this read range data into that.
Anyone assist me to fix this prob!!!
Thanks a lot!!!