View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zeus Zeus is offline
external usenet poster
 
Posts: 6
Default Changing formulas in Excel that relate to Pivit tables

Can someone tell me how to turn of the ChangeEvent triger in excel?

I have some pivot tables that when I update the formulas, the system updates
all the of data that is linked to an Access database. This is a major
productivity issue since each update takes about 10 minutes and for each file
I have 3 columns that need to be updated.