View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NiNi NiNi is offline
external usenet poster
 
Posts: 4
Default How to split the active sheets into two different work windows?

How to split the active sheets into two different work windows and work
independently. For example, the top part runs PIVOT Table, and the lower part
generate the summary. Whenever the PIVOT table, refresh, it wouldn't cover
the lower part. Any idea is appreciated. Thank you.