View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hamish Hamish is offline
external usenet poster
 
Posts: 14
Default Custom functions not updating when dependant cells are edited

Hi

I have a problem where I use a custom function that analyses data in other
cells. When the contents of the other cells are edited the cell that uses the
custom function does not automatically update. The only way that it updates
is if you click on the cell then click on the function and click enter again.

Is there a way that the result of the cell with the custom function can
automatically update when the other cells are edited?

Thanks