View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nigelbellamy[_3_] nigelbellamy[_3_] is offline
external usenet poster
 
Posts: 1
Default Preventing linked cells from updating

In order to optimise the run time of a macro i have written i would lik
to stop the excel worksheet from performing any unnecessar
calculations.

My macro is altering the values in many cells in a worksheet. Thes
cells are then the basis for a secondary set of calculations, both o
the same worksheet and another worksheet.

Is there a way of specifying which of cells or links that are dependen
on the cell that the macro is altering should be refreshed every tim
that particular cell is altered?

Thanks



--
Message posted from http://www.ExcelForum.com