View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randy Starkey Randy Starkey is offline
external usenet poster
 
Posts: 16
Default Pivot Table problems

Hi,

1) Can I have 2 different PTables in a workbook that use the same sheet as
data? It seems like if I copy a PTable, and then make changes in the copy,
it changes the original too! How to fix this?

2) I'd like to keep the PTable references updated for a chart that pulls
data from it. Is there code that can be written to a button that would
update the PTable from additional data added to a certain sheet, and then
refresh the chart that draws from the PTable?

Thanks!

Randy Starkey