How do you replace old data with new data without creating a new .
Hit the "Refresh Data" in the pivot table toolbar (looks like an exclamation
point)
--
Regards,
Dave
"Dena" wrote:
I have existing pivot tables and I want to replace the data source worksheet
with new data and the pivot tables update with the new information. I have
replace the data source but the pivot tables didn't update.
|