Pivot table with data replace error.

V

Vinod

I have a template with pivot table (without VBA code).

I am getting a message after downloading data from application to my
template with "Yes" "No" buttons. If I click on "Yes" its working fine. The
message dialog prompts with the following meesage.

"Do you want to replace the contents of the destination cells in Pivot
tabel1? "

My requirement is I don't want to get this type of messages, for this what
needs to be done (without VBA code).

Advanced Thanks,
Vinod
 
Top