Refresh Pivot table without losing the format
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!
|