Taking Longer to Launch Excel After Enabling Datalizer 5.0 Excel Plug-in.

KB#: 000015616
Last Updated: 18/Jan/2018

It may take longer to launch Microsoft Excel after enabling Excel plug-in of Datalizer version 5.0. You may also see the Name box blinking. 

Cause
This issue occurs due to animation function in GUI view which was added in Excel 2013 or later. It takes a long time for Excel plugin to display a custom task pane using the animation. This issue may not occur in remote desktop environment because animation is suppressed.

For detail, see It takes a long time for an add-in to display a custom task pane in a document in Office 2016 and Office 2013 

Resolution

• For Office 2016 MSI

1. if MSO version is fewer than 16.0.4312.1000, apply KB3114383.
2. Add following registry value in OS for each user.

• For Office 2016 Click-to-Run (C2R)
  Update to Microsoft Office Version 1705.
  
  
• For Office 2013 MSI

1. if MSO version is fewer than 15.0.4605.1000, apply KB2863880 or KB2825631.
2. Add following registry value in OS for each user. 

• For Office 2013 Click-to-Run (C2R)
  It's no longer supported by Microsoft. Upgrade to Office 2016.

Not sure what version of installer you have now? See Determining your Office version – MSI vs. C2R.

Supplemental Information

How to distribute registry entry in batch program:

1. Create following file and rename "Office_DisableWindowTransitionsOnAddinTaskPanes.reg"
   
   Windows Registry Editor Version 5.00
   
   [HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Toolbars]          "DisableWindowTransitionsOnAddinTaskPanes"=dword:00000001
   
   [HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Toolbars] "DisableWindowTransitionsOnAddinTaskPanes"=dword:00000001
   
   
2. Create following file in the same location above and rename "Office_DisableWindowTransitionsOnAddinTaskPanes.bat"
   
   reg import Office_DisableWindowTransitionsOnAddinTaskPanes.reg
   
   
3. Run "Office_DisableWindowTransitionsOnAddinTaskPanes.bat" as each user.
   Admin permission is not required when edit permission of registry editor is granted.

For users who are not granted edit permission of registry entry:

Executing the batch file ends up with an error "Registry editing has been disabled by your administrator" when Prevent access to registry editing tools is enabled in Group Policy. In this case these two values included in "Office_DisableWindowTransitionsOnAddinTaskPanes.reg" above can be added by using Registry Distribution in Group Policy. For detail see Configure a Registry Item.