Oracle Smart View for Office does not support Excel’s Transition navigation keys option.
Due to a Microsoft limitation, many of the Microsoft APIs that Smart View depends on for both Smart View and Excel functionality do not work when the Transition navigation keys option is enabled. For example:
In Excel, copy/paste, macros, automation API calls do not work correctly.
In the Planning Admin extension, member formula formatting in the Smart View Dimension Editor does not display correctly; formulas have incorrect syntax when submitted to Oracle Hyperion Planning.
In order to ensure the best performance possible, Smart View requires the following:
The Excel option, Transition navigation keys, must be cleared.
The Smart View option, Improve Metadata Storage, must be enabled (by default, this option is enabled).