Pivot Table with Data replace error

  • Thread starter Thread starter Vinod
  • Start date Start date
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
 
The reason that you are getting that message is that you must have text or
formulas somewhere in the sheet you are putting the pivot tabel on. The pivot
table is going to overwrite that text or formulas so it is confirming that
you are ok with that. To avoid that problem do not have any text or formulas
below or to the right of your pivot table. That way there is nothing for the
pivot table to overwrite...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to clear pivot table catche 1
pivot table data 2
Pivot table magic 1
Pivot tables and replacing data, then refresh it 1
pivot table space question 1
Pivot Table Refresh? 2
How to Clear a Pivot Table Cache 1
How do I save Pivot Table Data 4

Back
Top