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?

I doubt that there is any way to disable a built-in function but it seems to
me that you're going about this backwards. You want to disable part of Excel
so a 3rd party (commercial?) add-in will work. How about getting add-ins
that work properly? If the add-in isn't compatible with Excel 2007 you
should probably contact the add-in manufacturer.

Biff

"David" wrote in message
...
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?

It's probably unfair to cast aspersions on developers who developed
functions that work properly in XL97-03. Since XL hadn't implemented any
new functions in a decade, it perhaps wasn't a stretch to give them
straight-forward names like IFERROR() (though I prefer my more specific
IFNA()).


In article ,
"T. Valko" wrote:

it seems to me that you're going about this backwards. You want to
disable part of Excel so a 3rd party (commercial?) add-in will work.
How about getting add-ins that work properly?