Excel PowerQuery Instability

Copper Contributor

I've been using PowerQuery for a long time and one thing that has not changed is it's instability.  When I'm using two workbooks, which both have a PowerQuery they become unstable, a 'SEND A FROWN' error comes up and half the time, Excel crashes (all open WorkBooks crash/disapear), Excel comes back trying to repair all of them.

No matter how many times they are repaired (including manually), they still do it.  If I don't need them to interact with each other, I can open them up in different instances (Win+R > excel -x), but sometimes I need them working together.

Below is the detail of the error from the 'SEND A FROWN error'.

 

What is going on, why is not fixed yet and what can I do about it.

 

Feedback Type:
Frown (Error)

Error Message:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Stack Trace:
Error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at WorkbookQueriesNavigatorViewHost.prototype.showNodeContextMenu (ms-pq://pq.microsoft.com/ts/TaskPane/WorkbookQuery/WorkbookQueriesNavigatorViewHost.js:122:13)
at Anonymous function (ms-pq://pq.microsoft.com/ts/Shared/ResultViews/NavigatorViewControl.js:175:21)
at n.event.dispatch (ms-pq://pq.microsoft.com/opensource/jquery/jquery-2.1.1.js:3:6348)
at r.handle (ms-pq://pq.microsoft.com/opensource/jquery/jquery-2.1.1.js:3:3114)

Stack Trace Message:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo)
at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass2.<InvokeMember>b__0()
at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)


Supports Premium Content:
True

 

0 Replies