When a pivot table refresh will prompt "replace the contents" where some data below the table.

Could it be preset the answer in "Yes" ? Means always replace.

Thanks