Oracle Smart View Hangs on Member Selection
Smart View’s member selection function can cause Microsoft Excel to hang and become unresponsive. The lock up prevents Excel from responding to user commands, so many users forcibly end and restart Excel to continue using Smart View. This can potentially cause loss of any unsaved updates.
The issue in this situation is that the Smart View Member Selection dialogue is rendered off screen. This causes Excel to become unresponsive because the dialogue requires a member to be selected before the user can return to the Excel sheet. To make things more challenging, the default member selection is blank, pressing enter sounds a system error chime and renders another message dialogue off screen.
The Member Selection dialogue renders on the display windows considers its “primary” display. However, from time-to-time the display configuration can change after Excel has been launched.
One example situation that can cause this issue:
• MS Excel is launched from an notebook computer with an external monitor attached as the “primary” display
• The laptop is disconnected from the external display and brought into a conference room to be connected to a projector
• The projector is treated as a new display to Windows, but is not configured as Windows’ “primary” display output
• Excel tries to render dialogue boxes to the “primary” display, even when the display is no longer connected
The result is that Excel becomes unresponsive because the Member Select dialogue cannot be easily cleared.
The simplest and most straightforward fix to help Excel become responsive is to simply use the [Esc] key to back out of the Member Select dialogue. Even though the window is not on screen, it can still be controlled.
Unfortunately, escaping the dialogue does not enable us to use the Member Select function, at least not without exiting and re-launching Excel or changing the display configuration back to its original setup.
A simple option to pull the off-screen Member Selection box back into view is to use the key combination Alt + Space + m. This selects the window’s ‘Move’ function, enabling the user to use the keyboard arrow keys to move the window into the viewable screen.
Did this method resolve your issue? Having other Smart View issues and need help? Let us know in the comments!