View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yhoy yhoy is offline
external usenet poster
 
Posts: 27
Default 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!