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.

Convert unrecoverable references to:

0. values
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\Microsoft\Office\12.0\Excel\Options
   Value Name	ExtractDataFormulas
   Value Type	REG_DWORD
   Value	2

1. #REF or #NAME
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\Microsoft\Office\12.0\Excel\Options
   Value Name	ExtractDataFormulas
   Value Type	REG_DWORD
   Value	1