View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default can a function be disabled?

Is there any way to turn off the iferror function in Excel 2007? The new
function has wrecked havoc on our receipt of client excel files. We receive
client files that contain 3rd party custom code where the authors created
their own iferror logic. The code is protected and inaccessible and the
workbooks are locked as well. Excel 2007 locks up with a display of a compile
error that requires a ctrl alt delete end task to get out of if we attempt to
open a client file. We've rolled some machines back to Office Excel 2003 to
resolve the issue. It occured to me that if I could just shut off the new
excel iferror built in function the issue should resolve in 2007. Any way to
turn off or uninstall a built in function?