Pivot table - default answer
 

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


--
keith
------------------------------------------------------------------------
keith's Profile: http://www.excelforum.com/member.php...o&userid=16242
View this thread: http://www.excelforum.com/showthread...hreadid=525198