Share via

Error refreshing a query in Excel: Unexpected error: Could not load file or assembly 'Microsoft.mshtml

Anonymous
2023-04-27T12:28:33+00:00

Hello
I tried to refresh a Excel file with queries and a new error is displayed since today.
The error is happening at the last step of the query below. Below you will also find the error message.
I tried to clear all the permissions but nothing changed. Any ideas on how to fix it?

Query:

let 

Source = Mail, 

#"Filtered Rows1" = Table.SelectRows(Source, each ([Folder Path] = "\Posteingang\APO\_jobs\ZDLC1\_DACH\") and ([HasAttachments] = true)), 

#"Filtered Rows2" = Table.SelectRows(#"Filtered Rows1", let latest = List.Max(#"Filtered Rows1"[DateTimeReceived]) in each [DateTimeReceived] > latest - #duration(0,0,59,0)), 

#"Expanded Attachments" = Table.ExpandTableColumn(#"Filtered Rows2", "Attachments", {"Extension", "AttachmentContent"}, {"Extension", "AttachmentContent"}), 

#"Filtered Rows" = Table.SelectRows(#"Expanded Attachments", each Text.StartsWith([Extension], ".htm")), 

Navigation1 = #"Filtered Rows"{1}[AttachmentContent], 

#"Imported HTML" = Web.Page(Navigation1)

in 

#"Imported HTML"

Mail is :

let 

Source = Exchange.Contents("******@danone.com"), 

Mail1 = Source{[Name="Mail"]}[Data]

in 

Mail1

Error message:

Unexpected error: Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

Details: 

Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. ---> System.Exception: Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. ---> System.Exception: Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

at Microsoft.Mashup.Engine1.Library.Html.NoUIWebBrowser.CreateWebBrowserSiteBase()

at System.Windows.Forms.WebBrowser.Dispose(Boolean disposing)

at System.ComponentModel.Component.Dispose()

at Microsoft.Mashup.Engine1.Library.Html.Browser.ThreadCreate()

--- End of inner exception stack trace ---

at Microsoft.Mashup.Engine1.Library.Html.Browser..ctor(IEngineHost host, String text, Request request)

at Microsoft.Mashup.Engine1.Library.Html.Browser.GetDomFromText(IEngineHost host, String text)

at Microsoft.Mashup.Engine1.Library.Html.HtmlModule.PageFunctionValue.TypedInvoke(Value html)

at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue1`2.Invoke(Value arg0)

at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)

at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)

at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)

at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)

at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)

at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)

at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name)

at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)

at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()

at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.Force(Int32 index)

at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.get_Item(Int32 index)

at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)

at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)

at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)

at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.Instruction.ExecuteCondition(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.DebugInstruction.ExecuteCondition(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)

at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)

at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)

at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)

at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()

at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

--- End of inner exception stack trace ---

at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResultT

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResultT

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)

at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)

at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.EvaluationHost.Run()

at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)

at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)

at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)

at Microsoft.Mashup.Container.BootstrapAppDomainManager.Execute(String[] argv)

--- End of inner exception stack trace ---

at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.<BeginGetResult>b__0(EvaluationResult2`1 result)

--- End of inner exception stack trace ---

at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.<BeginGetResult>b__0(EvaluationResult2`1 result)

at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)

at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResultT

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResultT

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)

at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)

at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.EvaluationHost.Run()

at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)

at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)

at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)

at Microsoft.Mashup.Container.BootstrapAppDomainManager.Execute(String[] argv)

--- End of inner exception stack trace ---

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass9_1.<OnBeginGetPreviewValueSource>b__1()

at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()

at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

--- End of inner exception stack trace ---

at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass14_0.<TryReportException>b__1()

at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)

at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)

at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()

at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResultT

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)

at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)

at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.EvaluationHost.Run()

at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)

at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)

at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)

at Microsoft.Mashup.Container.BootstrapAppDomainManager.Execute(String[] argv)

--- End of inner exception stack trace ---

at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)

at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitForT

at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)

at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()

at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()

at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult21 result, Func1 getStaleSince, Func`1 getSampled)

Thanks in advance for the help.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-04-28T14:15:37+00:00

    It is suggested to raise a ticket to Microsoft. Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. That support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-04-28T13:23:41+00:00

    I installed the software and the same error is still displayed. I have restarted my laptop in between.
    Is there any additional step ?

    thanks

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-04-27T16:52:17+00:00

    Error:"Could not load file or assembly 'Microsoft.mshtml, Version=7.0.3300.0

    Cause

    The .NET Framework Version 2.0 Software Development Kit is required in order to use Visual Web Developer 2008 Express Edition with the .NET Web ADF.

    Solution or Workaround
    Navigate to the MSDN .NET Framework Developer Center.

    1. Download the (x86) version of the .NET Framework Version 2.0 Software Development Kit (SDK).
    2. Launch the setup and install the ‘Tools and Debugger’ feature.

    Reference:

    Error: Could Not Load File or Assembly 'Microsoft.mshtml, Version=7.0.3300.0 (esri.com)

    Was this answer helpful?

    0 comments