Depending on how that cell is used in other calculations, it may be useful to
try the linked cell.

Excel is pretty smart. It knows which cells change and which cells need to be
recalculated.

But if that formula cell that refers to the linked cell is used in loads of
other cells, I see your point.

d.stephanou@gmail.com wrote:
>
> Thanks for that I'll give it a shot.
>
> The problem is that I am working on a big spreadsheet involving lots of
> calculations, so I'm using the manual calculation option. The problem
> is that this option prohibits the 'target' cell from updating itself -
> unless I press F9 each time - so I am forced to use the automatic
> option instead. This effectively means that for the slightest change
> the spreadsheet will calculate itself over and over, practically making
> the spin button a redundancy.
>
> I'd rather first set the values my decision variables (3 in total) and
> then have the spreadsheet execute the calculations by pressing F9.

--

Dave Peterson