I’m opening 10excel files which has smart view in it.
while looping into excel application scope, it opens one by one most of the time i’m not finding smart view tab in it.
when I click to excel add-ins and unchecking “oracle smart view for office option” excel is restarting,
after checking SV its not enabled
kindly help me with this
You need to look at the load setting for Smartview. Its a common issue you are experiencing.
To enable the Smart View addin to display when opening Excel:
Open your registry editor. To do this, open your Windows Start menu and type “regedit”.
Go to HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Hyperion.CommonAddin. Ensure the LoadBehavior is set to 3.
If the LoadBehavior is anything other than “3” then follow these steps:
a. Close Excel. Make sure the “excel.exe” process is not running in the Windows Task Manager.
b. Open the registry editor again. Double-click the registry key to edit it.
c. Change the Load Behavior to “3.” Close the registry editor.
d. Re-open the registry editor to ensure “3” is still there.
Open Excel. The Smart View add-in should now load automatically at startup.
March 23, 2019, 5:43am
Dears, I am facing the same problem, the excel application scope always lost the smart view add-ins, and the registry is right. Has any other solution? Thanks!
When you open Excel manually, can you see the smartview add in on the ribbon?
March 25, 2019, 1:34pm
Yes, when I open the Excel manually or use open application activities, I can see the smart view add-ins, but use excel application scope, the add-ins can’t display. Thanks!
You may want to consider opening the file using the start process activity then using the hot keys in excel to navigate to the SmartView panel and refresh your workbook.
Once you’ve connected and logged in, you can grab the smartview data, move it to a follow up excel file and you can begin using the excel application scope from that point.
Main.xaml (6.2 KB)
March 26, 2019, 1:55am
Thanks a lot! It can walk around the problem! Also expect excel application scope to support the add-ins!
Great, please mark as a solution.
You should submit the bug to UiPath so that they can enhance the excel application scope activity in their next release.