locked
Virtualized addin slows down Excel RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    Software: Oracle SmartView 11.1.2.3

    OS: Windows Server 2016 (SBC)

    MS Office: 2016 (365)

    I have packaged the latest Oracle SmartView software which contains an Office addin.

    The customer mainly uses the Excel addin.

    When I launch Excel with the addin following key is created with as content strange keys with hexadecimal data.

    HKEY_CURRENT_USER\SOFTWARE\Microsoft\AppV\Client\Packages\PackageID\REGISTRY\USER\UserSID\Software\Microsoft\Office\16.0\Excel\Resiliency\StartupItems


    When you start using sheets with the addin more lines are added in the key.

    The more keys are added, the slower the App becomes and hangs after a while.

    I have performed a local installation of the SmartView software and that works fine.

    So it seems the App-V layer is causing the issue, but I cannot figure out what.

    Does anyone have an idea?



    Thanks for your help.

    Stefaan



    • Edited by stefaan_c Thursday, June 25, 2020 11:54 AM Update
    Thursday, June 25, 2020 11:53 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    I would first start by excluding the office hive from hooking, to do so, add the following regkeys to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\AppV\Subsystem\VirtualRegistry\PassThroughPaths:

    HKEY_CURRENT_USER\Software\Microsoft\Office\16.0
    HKEY_CURRENT_USER\Software\Microsoft\Office\Common
    HKEY_CURRENT_USER\Software\Microsoft\Office\Lync

    If you have any virtualized Excel Automation Add-ins, which are innitiated though the regkey ..\Office\16.0\Excel\Options\OPEN, you need to set this key in the local registry.

    Also make sure the following key is set:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ClickToRun\OverRide
    AllowJitvInAppvVirtualizedProcess dword=1

    Roy Essers


    • Edited by Roy Essers Friday, June 26, 2020 6:06 PM
    • Marked as answer by stefaan_c Monday, June 29, 2020 8:21 AM
    Friday, June 26, 2020 6:05 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I would first start by excluding the office hive from hooking, to do so, add the following regkeys to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\AppV\Subsystem\VirtualRegistry\PassThroughPaths:

    HKEY_CURRENT_USER\Software\Microsoft\Office\16.0
    HKEY_CURRENT_USER\Software\Microsoft\Office\Common
    HKEY_CURRENT_USER\Software\Microsoft\Office\Lync

    If you have any virtualized Excel Automation Add-ins, which are innitiated though the regkey ..\Office\16.0\Excel\Options\OPEN, you need to set this key in the local registry.

    Also make sure the following key is set:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ClickToRun\OverRide
    AllowJitvInAppvVirtualizedProcess dword=1

    Roy Essers


    • Edited by Roy Essers Friday, June 26, 2020 6:06 PM
    • Marked as answer by stefaan_c Monday, June 29, 2020 8:21 AM
    Friday, June 26, 2020 6:05 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    We have the same issue Eikon excel takes ages to load and occasionally doesn't load excel becomes stuck on processing and it's very slow whilst using the add-in and Oracle Smartview is very slow when using the functions to REFRESH in essbase/smartview to the point excel stops responding for minutes at a time. I ran a procmon and it refers to the same registry the Resiliency startup folder, I've also noticed we don't have your suggestions in the VirtualPassthrough which is interesting.

    one strange thing I've noticed this key Computer\HKEY_USERS\S-1-5-21-1616267453-2574176523-4078767703-155198\Software\Microsoft\AppV\Client\PackageGroups\9A35F268-2977-4654-A0D9-DA49FA7E81C6 seems to be the O365 addin's which come with O365 2016 I think this is to do without our connection group, anyway I will try adding the registry's above to virtualPassThrough.
    We do have the     AllowJitvInAppvVirtualizedProcess dword=1

    W10  2004

    Xendesktop LTSR 7.15 Cu3

    Excel 365 large spec 4vcpu 16gig ram, 

    Monday, June 29, 2020 3:40 PM