View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vinod[_2_] Vinod[_2_] is offline
external usenet poster
 
Posts: 72
Default Pivot Table with Data replace error

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