Fred, hein?
É possível e geralmente recomendado desativar os cálculos automáticos de planilhas, especialmente em planilhas grandes com fórmulas complexas. Um desses métodos é fornecido no Site "dummies" :
To put the workbook into manual recalculation mode, you select the Manual option on the Calculation Options’ button on the Formulas tab of the Ribbon (Alt+MXM). After switching to manual recalculation, Excel displays CALCULATE on the status bar whenever you make a change to the worksheet that somehow affects the current values of its formulas. Whenever Excel is in Calculate mode, you need to bring the formulas up-to-date in your worksheets before saving the workbook (as you would do before you print its worksheets).
To recalculate the formulas in a workbook when calculation is manual, press F9 or Ctrl+= (equal sign) or select the Calculate Now button (the one with a picture of a calculator in the upper-right corner of the Calculation group) on the Formulas tab (Alt+MB).
Outros links da minha pesquisa forneceram a justificativa específica para evitar erros de referência circular.