SharePoint 2019 - Could not load file 'Microsoft.Office.Excel.WebUI.Internal, Version=16.0.0.0

%3CLINGO-SUB%20id%3D%22lingo-sub-508744%22%20slang%3D%22en-US%22%3ESharePoint%202019%20-%20Could%20not%20load%20file%20'Microsoft.Office.Excel.WebUI.Internal%2C%20Version%3D16.0.0.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-508744%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20seems%20that%20SharePoint%202019%20(at%20least%20on%20version%26nbsp%3B16.0.10342.12113)%20is%20missing%20the%26nbsp%3BMicrosoft.Office.Excel.WebUI.Internal.dll%26nbsp%3B%20I%20am%20not%20sure%20if%20this%20was%20just%20done%20on%20purpose%20or%20just%20a%20miss%20from%20Microsoft.%3C%2FP%3E%3CP%3EMissing%20that%20dll%20caused%20Excel%20Web%20Online%20not%20to%20render%20in%20PerformancePoint%20(yes%2C%20I%20know.%20PerformancePoint....%20Sigh)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EError%20Message%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3ESorry%2C%20something%20went%20wrong%3CBR%20%2F%3ECould%20not%20load%20file%20or%20assembly%20'Microsoft.Office.Excel.WebUI.Internal%2C%20Version%3D16.0.0.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3D71e9bce111e9429c'%20or%20one%20of%20its%20dependencies.%20The%20system%20cannot%20find%20the%20file%20specified.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EFix%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3EI%20grabbed%20the%20dll%20from%20C%3A%5CWindows%5CMicrosoft.NET%5Cassembly%5CGAC_MSIL%5CMicrosoft.Office.Excel.WebUI.Internal%5Cv4.0_16.0.0.0__71e9bce111e9429c%20on%20the%20SharePoint%202016%20Server%20and%20copied%20to%20SharePoint%202019.%3C%2FP%3E%3CP%3EI%20also%20modified%20the%20webconfig%20file%20with%20the%20following%20entries%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%26lt%3B%20dependentAssembly%26gt%3B%26nbsp%3B%20%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%26lt%3B%20assemblyIdentity%20name%3D%22Microsoft.Office.Excel.WebUI.Internal%22%20publicKeyToken%3D%2271e9bce111e9429c%22%20%2F%26gt%3B%26nbsp%3B%20%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%26lt%3B%20!--%20Assembly%20versions%20can%20be%20redirected%20in%20application%2C%20publisher%20policy%2C%20or%20machine%20configuration%20files.%20--%26gt%3B%26nbsp%3B%20%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%26lt%3B%20bindingRedirect%20oldVersion%3D%2215.0.0.0%22%20newVersion%3D%2216.0.0.0%22%2F%26gt%3B%26nbsp%3B%20%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%26lt%3B%20%2FdependentAssembly%26gt%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%3CSAFECONTROL%20assembly%3D%22%26quot%3BMicrosoft.Office.Excel.WebUI.Internal%2C%22%20version%3D%2212.0.0.0%2C%22%20culture%3D%22neutral%2C%22%20publickeytoken%3D%2271e9bce111e9429c%26quot%3B%22%20namespace%3D%22%26quot%3BMicrosoft.Office.Excel.WebUI.Internal%26quot%3B%22%20typename%3D%22%26quot%3B*%26quot%3B%22%3E%3C%2FSAFECONTROL%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%3CSAFECONTROL%20assembly%3D%22%26quot%3BMicrosoft.Office.Excel.WebUI.Internal%2C%22%20version%3D%2214.0.0.0%2C%22%20culture%3D%22neutral%2C%22%20publickeytoken%3D%2271e9bce111e9429c%26quot%3B%22%20namespace%3D%22%26quot%3BMicrosoft.Office.Excel.WebUI.Internal%26quot%3B%22%20typename%3D%22%26quot%3B*%26quot%3B%22%3E%3C%2FSAFECONTROL%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%3CSAFECONTROL%20assembly%3D%22%26quot%3BMicrosoft.Office.Excel.WebUI.Internal%2C%22%20version%3D%2215.0.0.0%2C%22%20culture%3D%22neutral%2C%22%20publickeytoken%3D%2271e9bce111e9429c%26quot%3B%22%20namespace%3D%22%26quot%3BMicrosoft.Office.Excel.WebUI.Internal%26quot%3B%22%20typename%3D%22%26quot%3B*%26quot%3B%22%3E%3C%2FSAFECONTROL%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%3CSAFECONTROL%20assembly%3D%22%26quot%3BMicrosoft.Office.Excel.WebUI.Internal%2C%22%20version%3D%2216.0.0.0%2C%22%20culture%3D%22neutral%2C%22%20publickeytoken%3D%2271e9bce111e9429c%26quot%3B%22%20namespace%3D%22%26quot%3BMicrosoft.Office.Excel.WebUI.Internal%26quot%3B%22%20typename%3D%22%26quot%3B*%26quot%3B%22%3E%3C%2FSAFECONTROL%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20posting%20here%20in%20case%20might%20help%20someone%20else.%26nbsp%3B%20Not%20sure%20what%20happened%20but%20it%20seems%20Microsoft%20missed%20that%20dll.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-508744%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%202019%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1124657%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%202019%20-%20Could%20not%20load%20file%20'Microsoft.Office.Excel.WebUI.Internal%2C%20Version%3D16.0.0.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1124657%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F331413%22%20target%3D%22_blank%22%3E%40Piscus%3C%2FA%3E%26nbsp%3B%20i%20have%20added%20the%20DLL%20and%20edited%20web.config%20file.%20still%20i%20am%20getting%20the%20same%20error%20even%20after%20doing%20IISRESET%20and%20server%20reboot.%20Please%20assist.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

It seems that SharePoint 2019 (at least on version 16.0.10342.12113) is missing the Microsoft.Office.Excel.WebUI.Internal.dll  I am not sure if this was just done on purpose or just a miss from Microsoft.

Missing that dll caused Excel Web Online not to render in PerformancePoint (yes, I know. PerformancePoint.... Sigh)

 

Error Message:

Sorry, something went wrong
Could not load file or assembly 'Microsoft.Office.Excel.WebUI.Internal, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

 

 

Fix:

I grabbed the dll from C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.Office.Excel.WebUI.Internal\v4.0_16.0.0.0__71e9bce111e9429c on the SharePoint 2016 Server and copied to SharePoint 2019.

I also modified the webconfig file with the following entries:

 

< dependentAssembly>   
 < assemblyIdentity name="Microsoft.Office.Excel.WebUI.Internal" publicKeyToken="71e9bce111e9429c" />   
 < !-- Assembly versions can be redirected in application, publisher policy, or machine configuration files. -->   
 < bindingRedirect oldVersion="15.0.0.0" newVersion="16.0.0.0"/>   
 < /dependentAssembly>  
 
 <SafeControl Assembly="Microsoft.Office.Excel.WebUI.Internal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.Office.Excel.WebUI.Internal" TypeName="*" />
 <SafeControl Assembly="Microsoft.Office.Excel.WebUI.Internal, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.Office.Excel.WebUI.Internal" TypeName="*" />
 <SafeControl Assembly="Microsoft.Office.Excel.WebUI.Internal, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.Office.Excel.WebUI.Internal" TypeName="*" />
 <SafeControl Assembly="Microsoft.Office.Excel.WebUI.Internal, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.Office.Excel.WebUI.Internal" TypeName="*" />

 

 

Just posting here in case might help someone else.  Not sure what happened but it seems Microsoft missed that dll. 

1 Reply

@Piscus  i have added the DLL and edited web.config file. still i am getting the same error even after doing IISRESET and server reboot. Please assist.