Corrupt formula conversion

When Excel tries to recover formulas in an Open and Repair operation Excel converts a formula to a value or to #REF or #NAME if the recovery does not succeed. This setting also affects the default option when the user is prompted to recover formulas during the Open and Repair operation.

Supported on: At least Windows Vista
Convert unrecoverable references to:


  1. values
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\Excel\Options
    Value NameExtractDataFormulas
    Value TypeREG_DWORD
    Value2
  2. #REF or #NAME
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\Excel\Options
    Value NameExtractDataFormulas
    Value TypeREG_DWORD
    Value1


excel12.admx

Administrative Templates (Computers)

Administrative Templates (Users)