Disabling Excel Prompting when it detects a circular reference

E

ECE

Hi,

Does anyone know how to disable the MS Excel prompting of circular
references ? Thanks.
 
N

Nigel

Controlling the iterations, maxiterations and maxchange properties might
help. See Excel help. Use Tools->Options->Calculations to set or use VBA
Application.Iterations = True

Cheers
Nigel
 
S

Sandy V

Hi Adrian,

If you don't want to limit or control iterations, press
Cancel instead of OK when the prompt appears. Should
prevent it popping up again, at least while in the same
workbook.

Regards,
Sandy
 
Top