Office Unknown Exception Error on a Protected Sheet

Upon opening a password-protected worksheet, an exception is thrown as Oracle Smart View for Office tries to set Range.ID, required for duplicate (non-unique) member name support. An exception is also thrown by the Excel API on any operation that requires Smart View to write into worksheet if the worksheet is password protected.

Note that Smart View does not work with password-protected worksheets.

If possible, try the following workarounds:

• Remove password protection.
• Rewrite macros in a way that prevents Smart View from trying to write in password-protected worksheets.