Share via

Other in organisaiton can't update Excel file anymore

Emil P 1 Reputation point
2022-12-29T08:20:59.357+00:00

Hello

I have made an Excel report others use. The problem is they now can't update it anymore and the only that can is me and we don't know why.
I import data from an Excel file in Power Query make some transformation and make the data available in a Pivot table.

When they try to update, they file the get the following error: 

Feedback Type:  
Frown (Error)  
   
Error Message:  
Objektbeholderen afsluttede uventet med koden 0x80070002. PID: 11760.  
Anvendte funktioner: (ingen).  
   
Stack Trace:  
   
Server stack trace:   
   
   
Exception rethrown at [0]:   
   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
   ved Microsoft.Mashup.OleDbProvider.DataHost.BufferingMashupEvaluator.BufferingMashupEvaluation.GetBufferedReaderSource(AsyncResult`1 result)  
   ved Microsoft.Mashup.OleDbProvider.DataHost.BufferingMashupEvaluator.BufferingMashupEvaluation.OnEvaluationComplete(AsyncResult`1 result)  
   
Exception rethrown at [1]:   
   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
   ved Microsoft.Mashup.OleDbProvider.MashupCommandEvaluation.get_PageReader()  
   ved Microsoft.Mashup.OleDbProvider.MashupRowset.get__Rowset()  
   ved Microsoft.Mashup.OleDbProvider.MashupRowset.get_ColumnsInfo()  
   ved Microsoft.OleDb.Rowset.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)  
   ved Microsoft.OleDb.Command.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)  
   ved Microsoft.Mashup.OleDbProvider.TracingCommand.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)  
   
Stack Trace Message:  
Objektbeholderen afsluttede uventet med koden 0x80070002. PID: 11760.  
Anvendte funktioner: (ingen).  
   
Invocation Stack Trace:  
   ved Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)  
   ved Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)  
   ved Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)  
   ved Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()  
   ved Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_1.<SendAndMarshalExceptions>b__0(Object null)  
   ved System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)  
   ved System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)  
   ved System.Delegate.DynamicInvokeImpl(Object[] args)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)  
   ved System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbacks()  
   ved System.Windows.Forms.Control.WndProc(Message& m)  
   ved System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)  
   
   
InnerException0.Stack Trace Message:  
Objektbeholderen afsluttede uventet med koden 0x80070002. PID: 11760.  
Anvendte funktioner: (ingen).  
   
InnerException0.Stack Trace:  
   ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryCompleteWithException(Exception exception)  
   ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)  
   ved Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)  
   ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)  
   ved System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)  
   ved System.Threading.ThreadHelper.ThreadStart(Object obj)  
   
InnerException0.Invocation Stack Trace:  
   ved Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)  
   ved Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)  
   ved Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)  
   ved Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()  
   ved Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_1.<SendAndMarshalExceptions>b__0(Object null)  
   ved System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)  
   ved System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)  
   ved System.Delegate.DynamicInvokeImpl(Object[] args)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)  
   ved System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbacks()  
   ved System.Windows.Forms.Control.WndProc(Message& m)  
   ved System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)  
   
   
InnerException1.Stack Trace Message:  
Objektbeholderen afsluttede uventet med koden 0x80070002. PID: 11760.  
Anvendte funktioner: (ingen).  
   
InnerException1.Stack Trace:  
   ved Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Post(Message message)  
   ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.DataReaderSourceRemoteEvaluation.GetResult(Boolean enableFirewall)  
   ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)  
   
InnerException1.Invocation Stack Trace:  
   ved Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)  
   ved Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)  
   ved Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)  
   ved Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()  
   ved Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_1.<SendAndMarshalExceptions>b__0(Object null)  
   ved System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)  
   ved System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)  
   ved System.Delegate.DynamicInvokeImpl(Object[] args)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)  
   ved System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbacks()  
   ved System.Windows.Forms.Control.WndProc(Message& m)  
   ved System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)  
   
   
InnerException2.Stack Trace Message:  
Objektbeholderen afsluttede uventet med koden 0x80070002. PID: 11760.  
   
InnerException2.Stack Trace:  
   ved Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Post(Message message)  
   ved Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Post(Message message)  
   
InnerException2.Invocation Stack Trace:  
   ved Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)  
   ved Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)  
   ved Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)  
   ved Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)  
   ved Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()  
   ved Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_1.<SendAndMarshalExceptions>b__0(Object null)  
   ved System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)  
   ved System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)  
   ved System.Delegate.DynamicInvokeImpl(Object[] args)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)  
   ved System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)  
   ved System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)  
   ved System.Windows.Forms.Control.InvokeMarshaledCallbacks()  
   ved System.Windows.Forms.Control.WndProc(Message& m)  
   ved System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)  
   
   
Error Additional Details:  
EvaluationContainerLoader.cpp(126): Container starting with arguments: 19228 19224 82478a59-de79-4492-bd0f-aac97f919af2 111 --crashOnInitFailure  
EvaluationContainerLoader.cpp(64): Enumerating .net runtimes  
EvaluationContainerLoader.cpp(83): v4.0.30319  
EvaluationContainerLoader.cpp(87): Found match  
EvaluationContainerLoader.cpp(160): Loading runtime  
EvaluationContainerLoader.cpp(174): Starting runtime  
EvaluationContainerLoader.cpp(188): Executing managed entry point  
Container Managed entry point has started  
Container has started to run  
Pipes were set up  
Running the evaluation host  
Exception Occurred: Type: System.IO.FileNotFoundException. HR: -2147024894  
   ved Microsoft.Mashup.Host.Document.DependencyInjectionService..ctor()  
   ved Microsoft.Mashup.Host.Document.DependencyInjectionService.Get()  
   ved Microsoft.Mashup.Host.Document.TracingInitializer.Initialize(ITracingHost tracingHost)  
   ved Microsoft.Mashup.Host.Document.Evaluation.Services.RemoteTracingServiceFactory.ResetTraceListeners(ITracingHost tracingHost)  
   ved Microsoft.Mashup.Host.Document.Evaluation.Services.RemoteTracingServiceFactory.CreateProxy(IEngineHost engineHost, IMessenger messenger, BinaryReader proxyInitArgs)  
   ved Microsoft.Mashup.Evaluator.RemoteServiceEnvironment.CreateServiceProxies(IMessenger messenger, IRemoteServiceProxy[]& services)  
   ved Microsoft.Mashup.Evaluator.EvaluationHost.Run()  
   ved Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)  
   ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)  
End of exception data  
   
   
Supports Premium Content:  
False

Thanks for the help in advance

Microsoft 365 and Office | Excel | For business | Windows
Community Center | Not monitored
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,191 Reputation points Microsoft External Staff
    2022-12-30T01:24:55.947+00:00

    Hi @Emil P ,
    Which kind of authentication method did you use to create the connection?
    Try to check if you're using the Password or Windows authentication to create the connection.
    Make sure all users have the permission the access the source data.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.