On the pivot table options dialogue, uncheck autoformat

/jim

"yhoy" wrote:

Why after I update datasource (with same structure) and refresh Pivot chart,
all the setup are lost? Is there anyway to fix it-- ideal is by clicking one
button, all the charts/tables get updated.

Thanks a bunch!